Start Level 1 Node: About this guideAbout this guideEnd Level 1 Node: About this guide
      Start Level 2 Node: Who should read this guide?Who should read this guide?End Level 2 Node: Who should read this guide?
      Start Level 2 Node: User profilesUser profilesEnd Level 2 Node: User profiles
      Start Level 2 Node: About the documentation setAbout the documentation setEnd Level 2 Node: About the documentation set
   Start Level 1 Node: Getting StartedGetting StartedEnd Level 1 Node: Getting Started
      Start Level 2 Node: What is SAP BusinessObjects Analysis, edition for Microsoft Office?What is SAP BusinessObjects Analysis, edition for Microsoft Office?End Level 2 Node: What is SAP BusinessObjects Analysis, edition for Microsoft Office?
      Start Level 2 Node: Introduction to the Analysis Plug-inIntroduction to the Analysis Plug-inEnd Level 2 Node: Introduction to the Analysis Plug-in
      Start Level 2 Node: Working with Analysis in Microsoft ExcelWorking with Analysis in Microsoft ExcelEnd Level 2 Node: Working with Analysis in Microsoft Excel
      Start Level 2 Node: Working with Analysis in Microsoft PowerPointWorking with Analysis in Microsoft PowerPointEnd Level 2 Node: Working with Analysis in Microsoft PowerPoint
   Start Level 1 Node: Creating WorkbooksCreating WorkbooksEnd Level 1 Node: Creating Workbooks
      Start Level 2 Node: Creating and administrating workbooksCreating and administrating workbooksEnd Level 2 Node: Creating and administrating workbooks
         Start Level 3 Node: To insert a data source in a workbookTo insert a data source in a workbookEnd Level 3 Node: To insert a data source in a workbook
         Start Level 3 Node: To insert a data source into a default workbookTo insert a data source into a default workbookEnd Level 3 Node: To insert a data source into a default workbook
            Start Level 4 Node: To define a default workbookTo define a default workbookEnd Level 4 Node: To define a default workbook
         Start Level 3 Node: Calling the BEx Query Designer for editing a data sourceCalling the BEx Query Designer for editing a data sourceEnd Level 3 Node: Calling the BEx Query Designer for editing a data source
         Start Level 3 Node: To smart copy/paste a data sourceTo smart copy/paste a data sourceEnd Level 3 Node: To smart copy/paste a data source
         Start Level 3 Node: Inserting data sources using BW WorkspacesInserting data sources using BW WorkspacesEnd Level 3 Node: Inserting data sources using BW Workspaces
            Start Level 4 Node: To create a local providerTo create a local providerEnd Level 4 Node: To create a local provider
            Start Level 4 Node: To reload data in a local providerTo reload data in a local providerEnd Level 4 Node: To reload data in a local provider
            Start Level 4 Node: To create a CompositeProviderTo create a CompositeProviderEnd Level 4 Node: To create a CompositeProvider
         Start Level 3 Node: To open a workbookTo open a workbookEnd Level 3 Node: To open a workbook
         Start Level 3 Node: To save a workbookTo save a workbookEnd Level 3 Node: To save a workbook
         Start Level 3 Node: To save a query viewTo save a query viewEnd Level 3 Node: To save a query view
         Start Level 3 Node: To rename a workbookTo rename a workbookEnd Level 3 Node: To rename a workbook
         Start Level 3 Node: To delete a workbookTo delete a workbookEnd Level 3 Node: To delete a workbook
         Start Level 3 Node: To launch Analysis from a BW systemTo launch Analysis from a BW systemEnd Level 3 Node: To launch Analysis from a BW system
         Start Level 3 Node: To convert a BEx workbookTo convert a BEx workbookEnd Level 3 Node: To convert a BEx workbook
            Start Level 4 Node: Conversion logConversion logEnd Level 4 Node: Conversion log
      Start Level 2 Node: Defining style sets for crosstabsDefining style sets for crosstabsEnd Level 2 Node: Defining style sets for crosstabs
         Start Level 3 Node: SAP cell stylesSAP cell stylesEnd Level 3 Node: SAP cell styles
         Start Level 3 Node: To apply a style setTo apply a style setEnd Level 3 Node: To apply a style set
         Start Level 3 Node: To create a style setTo create a style setEnd Level 3 Node: To create a style set
         Start Level 3 Node: To share a style setTo share a style setEnd Level 3 Node: To share a style set
         Start Level 3 Node: To delete a style setTo delete a style setEnd Level 3 Node: To delete a style set
      Start Level 2 Node: Editing crosstabs with Table DesignEditing crosstabs with Table DesignEnd Level 2 Node: Editing crosstabs with Table Design
         Start Level 3 Node: To apply formatsTo apply formatsEnd Level 3 Node: To apply formats
         Start Level 3 Node: To add new cellsTo add new cellsEnd Level 3 Node: To add new cells
      Start Level 2 Node: Inserting other componentsInserting other componentsEnd Level 2 Node: Inserting other components
         Start Level 3 Node: To insert a dynamic chartTo insert a dynamic chartEnd Level 3 Node: To insert a dynamic chart
         Start Level 3 Node: To insert a waterfall chartTo insert a waterfall chartEnd Level 3 Node: To insert a waterfall chart
         Start Level 3 Node: To insert an info fieldTo insert an info fieldEnd Level 3 Node: To insert an info field
         Start Level 3 Node: To insert a filterTo insert a filterEnd Level 3 Node: To insert a filter
      Start Level 2 Node: Working with formulasWorking with formulasEnd Level 2 Node: Working with formulas
         Start Level 3 Node: To create a formulaTo create a formulaEnd Level 3 Node: To create a formula
         Start Level 3 Node: SAPGetDataSAPGetDataEnd Level 3 Node: SAPGetData
         Start Level 3 Node: SAPGetDimensionDynamicFilterSAPGetDimensionDynamicFilterEnd Level 3 Node: SAPGetDimensionDynamicFilter
         Start Level 3 Node: SAPGetDimensionEffectiveFilterSAPGetDimensionEffectiveFilterEnd Level 3 Node: SAPGetDimensionEffectiveFilter
         Start Level 3 Node: SAPGetDimensionInfoSAPGetDimensionInfoEnd Level 3 Node: SAPGetDimensionInfo
         Start Level 3 Node: SAPGetDimensionStaticFilterSAPGetDimensionStaticFilterEnd Level 3 Node: SAPGetDimensionStaticFilter
         Start Level 3 Node: SAPGetDisplayedMeasuresSAPGetDisplayedMeasuresEnd Level 3 Node: SAPGetDisplayedMeasures
         Start Level 3 Node: SAPGetInfoLabelSAPGetInfoLabelEnd Level 3 Node: SAPGetInfoLabel
         Start Level 3 Node: SAPGetMeasureFilterSAPGetMeasureFilterEnd Level 3 Node: SAPGetMeasureFilter
         Start Level 3 Node: SAPGetMemberSAPGetMemberEnd Level 3 Node: SAPGetMember
         Start Level 3 Node: SAPGetSourceInfoSAPGetSourceInfoEnd Level 3 Node: SAPGetSourceInfo
         Start Level 3 Node: SAPGetUniformScalingSAPGetUniformScalingEnd Level 3 Node: SAPGetUniformScaling
         Start Level 3 Node: SAPGetVariableSAPGetVariableEnd Level 3 Node: SAPGetVariable
         Start Level 3 Node: SAPGetWorkbookInfoSAPGetWorkbookInfoEnd Level 3 Node: SAPGetWorkbookInfo
         Start Level 3 Node: SAPListOfSAPListOfEnd Level 3 Node: SAPListOf
         Start Level 3 Node: SAPListOfDimensionsSAPListOfDimensionsEnd Level 3 Node: SAPListOfDimensions
         Start Level 3 Node: SAPListOfDynamicFiltersSAPListOfDynamicFiltersEnd Level 3 Node: SAPListOfDynamicFilters
         Start Level 3 Node: SAPListOfEffectiveFiltersSAPListOfEffectiveFiltersEnd Level 3 Node: SAPListOfEffectiveFilters
         Start Level 3 Node: SAPListOfMeasureFiltersSAPListOfMeasureFiltersEnd Level 3 Node: SAPListOfMeasureFilters
         Start Level 3 Node: SAPListOfMembersSAPListOfMembersEnd Level 3 Node: SAPListOfMembers
         Start Level 3 Node: SAPListOfMessagesSAPListOfMessagesEnd Level 3 Node: SAPListOfMessages
         Start Level 3 Node: SAPListOfStaticFiltersSAPListOfStaticFiltersEnd Level 3 Node: SAPListOfStaticFilters
         Start Level 3 Node: SAPListOfVariablesSAPListOfVariablesEnd Level 3 Node: SAPListOfVariables
         Start Level 3 Node: SAPSetFilterComponentSAPSetFilterComponentEnd Level 3 Node: SAPSetFilterComponent
      Start Level 2 Node: Converting crosstab cells to formulaConverting crosstab cells to formulaEnd Level 2 Node: Converting crosstab cells to formula
         Start Level 3 Node: To convert a crosstab to formulaTo convert a crosstab to formulaEnd Level 3 Node: To convert a crosstab to formula
      Start Level 2 Node: Working with macrosWorking with macrosEnd Level 2 Node: Working with macros
         Start Level 3 Node: SAPAddMessageSAPAddMessageEnd Level 3 Node: SAPAddMessage
         Start Level 3 Node: SAPCallMemberSelectorSAPCallMemberSelectorEnd Level 3 Node: SAPCallMemberSelector
         Start Level 3 Node: SAPExecuteCommandSAPExecuteCommandEnd Level 3 Node: SAPExecuteCommand
         Start Level 3 Node: SAPExecutePlanningFunctionSAPExecutePlanningFunctionEnd Level 3 Node: SAPExecutePlanningFunction
         Start Level 3 Node: SAPExecutePlanningSequenceSAPExecutePlanningSequenceEnd Level 3 Node: SAPExecutePlanningSequence
         Start Level 3 Node: SAPGetCellInfoSAPGetCellInfoEnd Level 3 Node: SAPGetCellInfo
         Start Level 3 Node: SAPGetPropertySAPGetPropertyEnd Level 3 Node: SAPGetProperty
         Start Level 3 Node: SAPLogOffSAPLogOffEnd Level 3 Node: SAPLogOff
         Start Level 3 Node: SAPLogonSAPLogonEnd Level 3 Node: SAPLogon
         Start Level 3 Node: SAPMoveDimensionSAPMoveDimensionEnd Level 3 Node: SAPMoveDimension
         Start Level 3 Node: SAPSetFilterSAPSetFilterEnd Level 3 Node: SAPSetFilter
         Start Level 3 Node: SAPSetPlanParameterSAPSetPlanParameterEnd Level 3 Node: SAPSetPlanParameter
         Start Level 3 Node: SAPSetRefreshBehaviourSAPSetRefreshBehaviourEnd Level 3 Node: SAPSetRefreshBehaviour
         Start Level 3 Node: SAPSetVariableSAPSetVariableEnd Level 3 Node: SAPSetVariable
         Start Level 3 Node: SAPSuppressMessageSAPSuppressMessageEnd Level 3 Node: SAPSuppressMessage
         Start Level 3 Node: Table Design APITable Design APIEnd Level 3 Node: Table Design API
            Start Level 4 Node: SAPSetFormatSAPSetFormatEnd Level 4 Node: SAPSetFormat
            Start Level 4 Node: SAPInsertLineSAPInsertLineEnd Level 4 Node: SAPInsertLine
            Start Level 4 Node: SAPSetTextSAPSetTextEnd Level 4 Node: SAPSetText
            Start Level 4 Node: SAPFixLineSizeSAPFixLineSizeEnd Level 4 Node: SAPFixLineSize
            Start Level 4 Node: SAPListOfDesignRulesSAPListOfDesignRulesEnd Level 4 Node: SAPListOfDesignRules
            Start Level 4 Node: SAPDeleteDesignRuleSAPDeleteDesignRuleEnd Level 4 Node: SAPDeleteDesignRule
         Start Level 3 Node: Using Analysis functionsUsing Analysis functionsEnd Level 3 Node: Using Analysis functions
         Start Level 3 Node: Hiding / Showing Analysis UI componentsHiding / Showing Analysis UI componentsEnd Level 3 Node: Hiding / Showing Analysis UI components
         Start Level 3 Node: Enhancing the Analysis RibbonEnhancing the Analysis RibbonEnd Level 3 Node: Enhancing the Analysis Ribbon
         Start Level 3 Node: Using BAdI informationUsing BAdI informationEnd Level 3 Node: Using BAdI information
         Start Level 3 Node: Using CallbacksUsing CallbacksEnd Level 3 Node: Using Callbacks
         Start Level 3 Node: Using LastError informationUsing LastError informationEnd Level 3 Node: Using LastError information
         Start Level 3 Node: Syntax for Entering ValuesSyntax for Entering ValuesEnd Level 3 Node: Syntax for Entering Values
   Start Level 1 Node: Analyzing DataAnalyzing DataEnd Level 1 Node: Analyzing Data
      Start Level 2 Node: Analyzing data with the design panelAnalyzing data with the design panelEnd Level 2 Node: Analyzing data with the design panel
         Start Level 3 Node: The Analysis tabThe Analysis tabEnd Level 3 Node: The Analysis tab
         Start Level 3 Node: The Property View on the Analysis tabThe Property View on the Analysis tabEnd Level 3 Node: The Property View on the Analysis tab
         Start Level 3 Node: The Information tabThe Information tabEnd Level 3 Node: The Information tab
         Start Level 3 Node: The Components tabThe Components tabEnd Level 3 Node: The Components tab
         Start Level 3 Node: Pausing RefreshPausing RefreshEnd Level 3 Node: Pausing Refresh
         Start Level 3 Node: Managing components in the design panelManaging components in the design panelEnd Level 3 Node: Managing components in the design panel
      Start Level 2 Node: PromptingPromptingEnd Level 2 Node: Prompting
         Start Level 3 Node: To define prompt valuesTo define prompt valuesEnd Level 3 Node: To define prompt values
         Start Level 3 Node: Using VariantsUsing VariantsEnd Level 3 Node: Using Variants
            Start Level 4 Node: To create a user-specific variantTo create a user-specific variantEnd Level 4 Node: To create a user-specific variant
            Start Level 4 Node: To create a global variantTo create a global variantEnd Level 4 Node: To create a global variant
            Start Level 4 Node: To apply a variantTo apply a variantEnd Level 4 Node: To apply a variant
            Start Level 4 Node: To change a variantTo change a variantEnd Level 4 Node: To change a variant
            Start Level 4 Node: To delete a variantTo delete a variantEnd Level 4 Node: To delete a variant
         Start Level 3 Node: To select workbook properties for promptingTo select workbook properties for promptingEnd Level 3 Node: To select workbook properties for prompting
      Start Level 2 Node: Filtering dataFiltering dataEnd Level 2 Node: Filtering data
         Start Level 3 Node: Filtering membersFiltering membersEnd Level 3 Node: Filtering members
            Start Level 4 Node: To filter data by memberTo filter data by memberEnd Level 4 Node: To filter data by member
            Start Level 4 Node: To filter data by member within hierarchiesTo filter data by member within hierarchiesEnd Level 4 Node: To filter data by member within hierarchies
            Start Level 4 Node: To filter members directly on the crosstabTo filter members directly on the crosstabEnd Level 4 Node: To filter members directly on the crosstab
            Start Level 4 Node: To filter out members directly on the crosstabTo filter out members directly on the crosstabEnd Level 4 Node: To filter out members directly on the crosstab
            Start Level 4 Node: To create a background filterTo create a background filterEnd Level 4 Node: To create a background filter
            Start Level 4 Node: To remove a filter by memberTo remove a filter by memberEnd Level 4 Node: To remove a filter by member
            Start Level 4 Node: Access mode for filteringAccess mode for filteringEnd Level 4 Node: Access mode for filtering
         Start Level 3 Node: Filtering measuresFiltering measuresEnd Level 3 Node: Filtering measures
            Start Level 4 Node: To filter data by measureTo filter data by measureEnd Level 4 Node: To filter data by measure
            Start Level 4 Node: Operators used for filtering measuresOperators used for filtering measuresEnd Level 4 Node: Operators used for filtering measures
            Start Level 4 Node: To change a filter by measureTo change a filter by measureEnd Level 4 Node: To change a filter by measure
            Start Level 4 Node: To remove a filter by measureTo remove a filter by measureEnd Level 4 Node: To remove a filter by measure
         Start Level 3 Node: To work with BEx conditions in AnalysisTo work with BEx conditions in AnalysisEnd Level 3 Node: To work with BEx conditions in Analysis
         Start Level 3 Node: To show/hide zeros in rows and columnsTo show/hide zeros in rows and columnsEnd Level 3 Node: To show/hide zeros in rows and columns
      Start Level 2 Node: Sorting dataSorting dataEnd Level 2 Node: Sorting data
         Start Level 3 Node: To sort valuesTo sort valuesEnd Level 3 Node: To sort values
         Start Level 3 Node: To sort membersTo sort membersEnd Level 3 Node: To sort members
      Start Level 2 Node: Working with hierarchiesWorking with hierarchiesEnd Level 2 Node: Working with hierarchies
         Start Level 3 Node: To include dimensions with hierarchies in an analysisTo include dimensions with hierarchies in an analysisEnd Level 3 Node: To include dimensions with hierarchies in an analysis
         Start Level 3 Node: To display single dimensions as hierarchyTo display single dimensions as hierarchyEnd Level 3 Node: To display single dimensions as hierarchy
      Start Level 2 Node: Calculating new measuresCalculating new measuresEnd Level 2 Node: Calculating new measures
         Start Level 3 Node: To calculate a new measure based on available measuresTo calculate a new measure based on available measuresEnd Level 3 Node: To calculate a new measure based on available measures
         Start Level 3 Node: To add a new measure based on one available measureTo add a new measure based on one available measureEnd Level 3 Node: To add a new measure based on one available measure
         Start Level 3 Node: To add a new measure based on free-form calculationTo add a new measure based on free-form calculationEnd Level 3 Node: To add a new measure based on free-form calculation
         Start Level 3 Node: To add a restricted measure for HANA data sourcesTo add a restricted measure for HANA data sourcesEnd Level 3 Node: To add a restricted measure for HANA data sources
      Start Level 2 Node: Defining Conditional FormattingDefining Conditional FormattingEnd Level 2 Node: Defining Conditional Formatting
         Start Level 3 Node: To define a conditional formatTo define a conditional formatEnd Level 3 Node: To define a conditional format
         Start Level 3 Node: To edit conditional formatsTo edit conditional formatsEnd Level 3 Node: To edit conditional formats
      Start Level 2 Node: Defining the display of members, measures and totalsDefining the display of members, measures and totalsEnd Level 2 Node: Defining the display of members, measures and totals
         Start Level 3 Node: To define the members displayTo define the members displayEnd Level 3 Node: To define the members display
         Start Level 3 Node: Defining the measures displayDefining the measures displayEnd Level 3 Node: Defining the measures display
            Start Level 4 Node: To define the number formatTo define the number formatEnd Level 4 Node: To define the number format
            Start Level 4 Node: To show or hide the scaling factorsTo show or hide the scaling factorsEnd Level 4 Node: To show or hide the scaling factors
            Start Level 4 Node: To define currency translationTo define currency translationEnd Level 4 Node: To define currency translation
            Start Level 4 Node: To define the display of zeros and negative valuesTo define the display of zeros and negative valuesEnd Level 4 Node: To define the display of zeros and negative values
         Start Level 3 Node: Defining the totals displayDefining the totals displayEnd Level 3 Node: Defining the totals display
            Start Level 4 Node: To locate the totals display in the crosstabTo locate the totals display in the crosstabEnd Level 4 Node: To locate the totals display in the crosstab
            Start Level 4 Node: To show or hide totals in the crosstabTo show or hide totals in the crosstabEnd Level 4 Node: To show or hide totals in the crosstab
            Start Level 4 Node: To define the calculation of totalsTo define the calculation of totalsEnd Level 4 Node: To define the calculation of totals
      Start Level 2 Node: To jump to a target with GotoTo jump to a target with GotoEnd Level 2 Node: To jump to a target with Goto
      Start Level 2 Node: To comment a data cellTo comment a data cellEnd Level 2 Node: To comment a data cell
   Start Level 1 Node: Analyzing SAP HANA dataAnalyzing SAP HANA dataEnd Level 1 Node: Analyzing SAP HANA data
      Start Level 2 Node: Analyzing SAP HANA data sourcesAnalyzing SAP HANA data sourcesEnd Level 2 Node: Analyzing SAP HANA data sources
   Start Level 1 Node: Planning DataPlanning DataEnd Level 1 Node: Planning Data
      Start Level 2 Node: To plan data manuallyTo plan data manuallyEnd Level 2 Node: To plan data manually
      Start Level 2 Node: To plan data with planning objectsTo plan data with planning objectsEnd Level 2 Node: To plan data with planning objects
      Start Level 2 Node: To recalculate planning dataTo recalculate planning dataEnd Level 2 Node: To recalculate planning data
      Start Level 2 Node: To save planning dataTo save planning dataEnd Level 2 Node: To save planning data
      Start Level 2 Node: Locking CellsLocking CellsEnd Level 2 Node: Locking Cells
         Start Level 3 Node: Front-End Cell LocksFront-End Cell LocksEnd Level 3 Node: Front-End Cell Locks
         Start Level 3 Node: Back-End Cell LocksBack-End Cell LocksEnd Level 3 Node: Back-End Cell Locks
         Start Level 3 Node: To lock cellsTo lock cellsEnd Level 3 Node: To lock cells
      Start Level 2 Node: Setting the Work StatusSetting the Work StatusEnd Level 2 Node: Setting the Work Status
         Start Level 3 Node: To set a work statusTo set a work statusEnd Level 3 Node: To set a work status
      Start Level 2 Node: To undo changes while planning dataTo undo changes while planning dataEnd Level 2 Node: To undo changes while planning data
      Start Level 2 Node: To switch between display and change modeTo switch between display and change modeEnd Level 2 Node: To switch between display and change mode
      Start Level 2 Node: Editing short texts in queriesEditing short texts in queriesEnd Level 2 Node: Editing short texts in queries
   Start Level 1 Node: Creating PresentationsCreating PresentationsEnd Level 1 Node: Creating Presentations
      Start Level 2 Node: To smart paste a data sourceTo smart paste a data sourceEnd Level 2 Node: To smart paste a data source
      Start Level 2 Node: Presentation settingsPresentation settingsEnd Level 2 Node: Presentation settings
   Start Level 1 Node: Creating Web ApplicationsCreating Web ApplicationsEnd Level 1 Node: Creating Web Applications
   Start Level 1 Node: Using Analysis in other SAP BusinessObjects ApplicationsUsing Analysis in other SAP BusinessObjects ApplicationsEnd Level 1 Node: Using Analysis in other SAP BusinessObjects Applications
      Start Level 2 Node: To save an analysis viewTo save an analysis viewEnd Level 2 Node: To save an analysis view
      Start Level 2 Node: To insert an analysis viewTo insert an analysis viewEnd Level 2 Node: To insert an analysis view
      Start Level 2 Node: To export a data source to the SAP BusinessObjects Design StudioTo export a data source to the SAP BusinessObjects Design StudioEnd Level 2 Node: To export a data source to the SAP BusinessObjects Design Studio
   Start Level 1 Node: SchedulingSchedulingEnd Level 1 Node: Scheduling
      Start Level 2 Node: Precalculation RestrictionsPrecalculation RestrictionsEnd Level 2 Node: Precalculation Restrictions
   Start Level 1 Node: SettingsSettingsEnd Level 1 Node: Settings
      Start Level 2 Node: User SettingsUser SettingsEnd Level 2 Node: User Settings
      Start Level 2 Node: Advanced SettingsAdvanced SettingsEnd Level 2 Node: Advanced Settings
      Start Level 2 Node: Platform SettingsPlatform SettingsEnd Level 2 Node: Platform Settings
      Start Level 2 Node: Support SettingsSupport SettingsEnd Level 2 Node: Support Settings
   Start Level 1 Node: TroubleshootingTroubleshootingEnd Level 1 Node: Troubleshooting
      Start Level 2 Node: To enable the Analysis Add-In after system crash (Microsoft Office 2010 and higher)To enable the Analysis Add-In after system crash (Microsoft Office 2010 and higher)End Level 2 Node: To enable the Analysis Add-In after system crash (Microsoft Office 2010 and higher)