Microsoft BI and SAP – New Whitepaper about unloading hierarchies from NetWeaver BI

  • Article

We just published a new whitepaper about Microsoft BI and SAP NetWeaver BI / SAP BW at https://download.microsoft.com/download/7/c/4/7c463654-e3ab-432b-809d-bcf4a7e99d4e/SAPBI%20-%20Unload%20Hierarchies.pdf written by Hermann Daeubler from the SQL Server team. The paper describes how to unload hierarchies from SAP NetWeaver BI 7.0. In SAP NetWeaver BI master data usually consists of attribute, text and hierarchy data. A simple example could be data about employees like name, age, title and so on in a SAP BI system. In addition one could store hierarchy information which describes the organization chart (who is a manager and who reports to whom?). The official interface in SAP NetWeaver BI to unload data is called Open Hub Service. It allows unloading master data of type “attribute” and “text” but has no option to unload hierarchy information. This raises the question how it could be accomplished to unload hierarchical information using other interfaces or mechanisms.

In addition to this paper you will also find BI related papers at https://www.microsoft.com/isv/sap/technology/interop/bi.aspx talking about

· Unloading Master Data from SAP BI 7.0 using XMLA and C#

· Unloading Master Data from SAP BI 7.0 using Open Hub Service

· Loading Data from SAP BW into Microsoft Analysis Services Using Open Hub Service

and more as well as some videos.

- Juergen