We just published a new whitepaper about Microsoft BI and SAP NetWeaver BI / SAP BW at http://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 http://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
