Connecting to SAP BW with Microsoft Excel PivotTables and ODBO
Microsoft Excel is considered by many to be the most commonly used BI tool in the world. Excel PivotTables are a practical way to access and analyze SAP BW data. Connecting PivotTables to a SAP BW data source is relatively straightforward, if you know a few important items that we will outline here. This paper includes a step-by-step description of the process that will get you connected to your data. Note that all steps presented here are for Excel 2007 connecting to SAP NetWeaver 2004s with BW patch level 12.