MS BPC - SQL DB Connection from ECC

[former_member184739]

Hi experts,

I have requirement to get MS BPC SQL table data from ECC report.
Question:
1) How to connect MS BPC SQL DB from ECC.
2) How to fetch some specific FI table data of SQL  from ECC.

Thanks.

[former_member186498 · Accepted solution]

Hi Prabaharan,

please see http://scn.sap.com/thread/3196295 and in particular the sap notes of Daniel and Stefan

http://scn.sap.com/thread/1945807 and

http://msdn.microsoft.com/en-us/library/dd299430.aspx maybe these helps.

Kind regards

     Roberto

[former_member184739 · Accepted solution]

Hello Roberto,

Can you please explain more as i am not clear from the threads you have suggested above?

Basically i want direct access of MS-BPC SQL table data from ECC either using ABAP code or any other provisions for it?

Please also note that i dont want to fetch data using BI DSO.

Thanks

Prabaharan