Microsoft Excel 2007 

Use

With OLE DB for OLAP for Microsoft Excel 2007, you can now connect your BI system directly to Microsoft Excel 2007 and analyze the BI data there in a pivot table report. You can use all the enhanced reporting and formatting functions of Microsoft Excel 2007 for the analysis. Users work in Excel only and do not need any prior knowledge of the Business Explorer front-end components.

Prerequisites

You have connected your BI system to Microsoft Excel 2007.

More information:

Connecting Microsoft Excel 2007 to a BI System

Features

You can use Microsoft Excel 2007 to access InfoCubes and queries as data sources from your BI system and to create a pivot table report from these data with the pivot table field list. You can save the report locally in a spreadsheet.

To perform this analysis, you need to be connected to the BI system. Offline analysis is not possible.

The analysis functions available with Microsoft Excel 2007 include:

●      Defining the query in the pivot table field list

●      Conditional formatting (top n rules, for example)

●      Inserting pivot charts

●      Using existing table and cell format templates

●      Using hierarchies

With time-dependent hierarchies, the key date is always today's date. This means that you cannot set a date of your choice (using variables, for example).

●      Displaying currencies

You can only use the following functions together with BEx Analyzer from the SAP NetWeaver Business Intelligence Suite:

●      Design mode

●      Formula Mode

●      Planning

●      Using variables

●      Currency translation

More information:

Analysis & Reporting: BEx Analyzer

Example

The graphic below shows an analysis in Microsoft Excel 2007 with a pivot table report, pivot table chart and pivot table field list (left):