Right now Analysis Office only supports BW/HANA as a data source; the EPM plug in can access MSAS and Essbase, so on the surface this is not possible.

Why not just use MS Access with Excel (instead of Analysis Office)? What is your business requirement?

Hi Tammy,

Thanks for your reply.

We have a Two Data sources 1. Non SAP Data source (MYSQL) 2. BW on HANA Data source

My requirements is we need to Pull data from BW and also from MS Access in the same Analysis Office excel workbook.

How to do this scenario, can you please explain very helpful to implement this scenario.

Thanks

Bharathi

HI,

Can you please help me following below requirement, it is very urgent.

We have a Two Data sources 1. Non SAP Data source (MYSQL) 2. BW on HANA Data source

My requirements is we need to Pull data from BW and also from MS Access in the same Analysis Office excel workbook.

How to do this scenario, can you please explain very helpful to implement this scenario.

Thanks in Advance......Guru.

Regards,

Bharathi