Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SAP BW Connector - Cube access

Dear all,   We currently had a discussion with our SAP BW provider. We're doing our whole reporting with Power BI and now we want to integrate SAP BW with the connector. Our provider doesn't want t...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    1. I mean, with what credentials do I have to sign in againt the SAP server? Because I don't see a point in the documentation where I have to type in my credentials.

     

    When get data from the SAP BW in Power BI desktop, it uses a user ID and a password for logon. See: Logon and Password Security in the ABAP-System.

     

     

     

    2. Or how do we have to secure it on SAP side? Does anybody ever had this problem to be only allowed to access one single cube?

     

    Power BI exposes queries and cubes exposed by the BW Open Analysis Interface OLAP BAPIs. The SAP BW logon user and permission setting are done on SAP BW side. You can contact your SAP BW administrator for help. Also you can post a question in SAP BW forum.

     

    Best Regards,
    Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi v-qiuyu-msft

 

Thank you for your input. But it isn't quite clear to me. 

 

I mean, with what credentials do I have to sign in againt the SAP server? Because I don't see a point in the documentation where I have to type in my credentials.

 

Or how do we have to secure it on SAP side?

 

Does anybody ever had this problem to be only allowed to access one single cube?

 

Roman

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Anonymous,

 

1. I mean, with what credentials do I have to sign in againt the SAP server? Because I don't see a point in the documentation where I have to type in my credentials.

 

When get data from the SAP BW in Power BI desktop, it uses a user ID and a password for logon. See: Logon and Password Security in the ABAP-System.

 

 

 

2. Or how do we have to secure it on SAP side? Does anybody ever had this problem to be only allowed to access one single cube?

 

Power BI exposes queries and cubes exposed by the BW Open Analysis Interface OLAP BAPIs. The SAP BW logon user and permission setting are done on SAP BW side. You can contact your SAP BW administrator for help. Also you can post a question in SAP BW forum.

 

Best Regards,
Qiuyun Yu

  • TORNALLY's avatar
    TORNALLY
    Helper I
    9 years ago

    One easy way to access SAP data from the source ECC system, rather than extracting it a second time from SAP BW, is through Simplement's Data Liberator.  This platform surfaces any SAP ECC (or CRM) table in real-time, and puts it directly into SQL Server, ready for Power BI.  

     

                         http://www.simplement.us/

     

    Mike McNally

    SAP BW specialist

    [email protected]