Connecting to SAP NetWeaver BI with Microsoft Excel 2007 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 NetWeaver BI data. Connecting PivotTables to a SAP NetWeaver BI 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 BI 7.0 with SPS 14.