Using MS Excel 2007 as MDX Client
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.
SAP Online Help: See the Architecture
SCN Paper: How to SetUp
SAP Note: How to Troubleshoot and trace
Link to this page: https://wiki.scn.sap.com/wiki/x/wYVYGg