Microsoft SAP Resources
Here are some great Microsoft SAP resources
SAP and SAP BW data in PowerPivot
using-sql-server-powerpivot-for-excel-to-analyze-sap-data.aspx.
SAP HANA data in PowerPivot
https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26747.
Microsoft Connector
https://msdn.microsoft.com/en-us/library/dd299430.aspx
BizTalk Adapter
https://msdn.microsoft.com/en-us/library/cc185427.aspx
XML/A Provider with .NET
https://msdn.microsoft.com/en-us/library/cc974473.aspx
SAP Excel ODBO connector, see:
Multiple SAP BI interoperability papers
https://www.microsoft.com/isv/sap/technology/interop/bi.aspx
SSIS and SAP BI White Paper
https://msdn.microsoft.com/en-us/library/dd299430.aspx
SSRS and SAP NetWeaver BI Technical Article
https://msdn.microsoft.com/en-us/library/cc974473.aspx
Microsoft .NET and SAP - Interoperability
https://www.microsoft.com/learning/en/us/Books/12513.aspx
SAP Business Information Warehouse:
https://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm
ODBO flattening algorithm: