SAP BusinessObjects Analysis, edition for Microsoft Office User Guide

Analysis User Guide

Getting Started

What is SAP BusinessObjects Analysis, edition for Microsoft Office?

Working with Analysis in Microsoft Excel 2007 and 2010

Working with Analysis in Microsoft PowerPoint 2007 and 2010

Working with Analysis in Microsoft Excel 2003

About this guide

Who should read this guide?

User profiles

About the documentation set

Creating Workbooks

Creating and administrating workbooks

To insert a data source in a workbook

To insert a data source into a default workbook

To define a default workbook

Calling the BEx Query Designer for editing a data source

Inserting data sources using BW Workspaces

To create a local provider

To reload data in a local provider

To create a CompositeProvider

To launch Analysis from a BW system

To convert a BEx workbook

Conversion log

Defining style sets for crosstabs

SAP cell styles

To apply a style set

To create a style set

To share a style set

To delete a style set

Inserting other components

To insert a dynamic chart

To insert a waterfall chart

To insert an info field

To insert a filter

Working with formulas

To create a formula

SAPGetData

SAPGetDimensionDynamicFilter

SAPGetDimensionEffectiveFilter

SAPGetDimensionInfo

SAPGetDimensionStaticFilter

SAPGetDisplayedMeasures

SAPListOfDynamicFilters

SAPListOfEffectiveFilters

SAPListOfMeasureFilters

SAPListOfMembers

SAPListOfMessages

SAPListOfStaticFilters

SAPListOfVariables

SAPSetFilterComponent

Converting crosstab cells to formula

To convert a crosstab to formula

Working with macros

SAPAddMessage

SAPCallMemberSelector

SAPExecuteCommand

SAPExecutePlanningFunction

SAPExecutePlanningSequence

SAPSetRefreshBehaviour

SAPSetVariable

Using Analysis functions

Hiding / Showing Analysis UI components

Enhancing the Analysis Ribbon

Using Callbacks

Using LastError information

Syntax for Entering Values

Analyzing Data

Analyzing data with the design panel

Managing components in the design panel

Prompting

To define prompt values

Using Variants

To create a user-specific variant

To create a global variant

To apply a variant

To change a variant

To delete a variant

To select workbook properties for prompting

Filtering data

Filtering members

To filter data by member

To filter data by member within hierarchies

To filter members directly on the crosstab

To filter out members directly on the crosstab

To create a background filter

To remove a filter by member

Access mode for filtering

Filtering measures

To filter data by measure

Operators used for filtering measures

To change a filter by measure

To remove a filter by measure

To work with BEx conditions in Analysis

To show/hide zeros in rows and columns

Sorting data

To sort values

To sort members

Working with hierarchies

To include dimensions with hierarchies in an analysis

To display single dimensions as hierarchy

Calculating new measures

To calculate a new measure based on available measures

To add a new measure based on one available measure

Defining Conditional Formatting

To define a conditional format

To edit conditional formats

Defining the display of members, measures and totals

To define the members display

Defining the measures display

To define the number format

To show or hide the scaling factors

To define currency translation

To define the display of zeros and negative values

Defining the totals display

To locate the totals display in the crosstab

To show or hide totals in the crosstab

To define the calculation of totals

To jump to a target with Goto

To comment a data cell

Analyzing SAP HANA data

Analyzing SAP HANA data sources

Planning Data

To plan data manually

To plan data with planning objects

To recalculate planning data

To save planning data

To undo changes while planning data

To switch between display and change mode

Editing short texts in queries

Creating Presentations

To create a slide out of Microsoft Excel

Presentation settings

Creating Web Applications

Using Analysis in other SAP BusinessObjects Applications

To save an analysis view

To insert an analysis view

To export a data source to the SAP BusinessObjects Design Studio

Scheduling

Precalculation Restrictions

To enable the Analysis Add-In after system crash (Microsoft Office 2007 and higher)

To enable the Analysis Add-In after system crash (Microsoft Excel 2003)

Solving issues regarding the creation of Microsoft PowerPoint slides