Microsoft has added additional OLAP functionality into native Excel 2007. The Pivot Tabel Services (PTS) allow to directly report on SAP BI data by using the Simba-/SAP-ODBO provider.
OLE DB for OLAP
Connecting to SAP NetWeaver BI with Microsoft Excel 2007 PivotTables and ODBO
1628813 Analyzing problems with SAP BW OLE DB Provider in Excel
Link to this page: https://wiki.scn.sap.com/wiki/x/wYVYGg