SAP Analysis for Microsoft Office(AO) is a Microsoft Office Add-In that allows multidimensional analysis of OLAP sources. It e.g. can be used to run BW queries where the query result is displayed in Microsoft Excel workbooks. The following topics provide additional information (from OLAP perspective) to consider when working with SAP BW queries in AO.
OLAP-Specific Topics
- New Calculated and Restricted Measures
- Calculate Totals As
- Background Filter
- Working with Hierarchies
- Hierarchies: Show Levels
- Hierarchies: Group Members/Adhoc Hierarchy
- 'Calculate result as..' & Hierarchies
- Function 'Only use Hierarchy for Filter' → see note 3156562
- Compact Display
- Zero Suppression
- Sort
- Conditions&Exceptions
- Prompt/Variable Screen
- Data Source Storage in Workbooks
- Authorization Checks
- Performance Analysis