June 2011

SQL CAT White Paper http://sqlcat.com/whitepapers/archive/2011/01/26/

SQL CAT white paper now available on how to use Power Pivot to empower business users to integrate and analyze SAP and non-SAP data to ease and accelerate analytics.  The paper reviews six scenarios where PowerPivot is used to analyze SAP ERP or SAP BW data:

– Importing data into PowerPivot via an Excel PivotTable connected  to SAP BW
– Importing data into PowerPivot via SQL Server Reporting Services  connected to SAP BW
– Importing data into PowerPivot from a text file generated using  SAP BW Open Hub Service
– Importing data into PowerPivot from a SQL Server Analysis Services   cube connected to SAP BW created using ERP-Link iNet.BI
– Importing data into PowerPivot using Xtract PPV connected to SAP BW
– Importing data into PowerPivot using Simplement Data Liberator connected to SAP ERP