The use of analysis is done mainly via the ribbon in excel. Individual features in the ribbon are enabled or disabled based on the type of data displayed and selected (Greyed out if disabled).



"Analysis" tab 

The Analysis tab contains the following groups:

GroupIconDescription

Insert Data source

Insert data from a source system into a crosstab

Refresh All

Refresh all data sources. The data sources are updated with the corresponding data from the server and the crosstabs are redrawn

GroupIconDescription

Undo

Undo last Analysis step

Redo

Redo last Analysis step

GroupIconDescription

Prompt

Enter values for Query parameters and variables

Filter

Define filter criteria for data

Sort

Sort data

Hierarchy 

Define hierarchy options such as expansion level and parent member positions

Calculations 

Define simple calculations (+,-,*,/) and dynamic calculations (for example, ranking and cumulation

GroupIconDescription

Member Display

Configure display for members (key/text)

Measure Display

Define display options for measures (for example, decimal places, scaling factors and currencies)

Totals (Show, Hide)

Configure display, position and calculation of totals

GroupIconDescription

Save Comment

New Comment

Delete Comment

Show/Hide Comment
GroupIconDescription

Save Data

Save plan values to InfoProvider

Recalculate

Recalculate plan values

Lock Cells

Lock and unlock input-ready cells

Work Status

Change the work status of the data source/selected cells

Display

Switch all data sources to display mode

Change

Switch all data sources to change mode

Back

Reset edited cells

GroupIconDescription

Display

Show/ Hide Design Panel.  

Pause Refresh

Activate/deactivate automatic refresh after each navigation step in the Design Panel.

"Analysis Design" tab 

The Analysis Design tab contains the following groups:

GroupIconDescription

Chart

Insert dynamic chart

Info Field

Insert information on data sources (for example, name and last data update)

Filter

Insert component for simple data filtering

GroupIconDescription

Undo

Undo last Analysis step

Redo

Redo last Analysis step

GroupIconDescription

Conditional Formatting 

Define rules for highlighting values using colors and symbols

New Lines

Insert/delete new rows or new columns

Format Cells

Format new cells or existing cells

Crosstab

Configure display options for the crosstab.

The following options are available:

  • Apply Default Formats
  • Display Symbols for Parent Members
  • Optimum Cell Width/Height
  • Repeat Members

Styles

Manage crosstab styles

GroupIconDescription

Combine

Group crosstabs or link dimensions

Create

Create Local Provider

Reload

Reload Local Provider

Add

Add Local Provider to Data Source

GroupIconDescription

Convert to Formula

Convert a crosstab into Excel formulas to retrieve the data.

Create Web Application

Transfer components in an Analysis workbook to the SAP BusinessObject Design Studio to create a web application

Launch Query Designer

Launch a query designer to check the query definition and to change the definition according to your needs

GroupIconDescription

Smart Copy

Copy data source to clipboard

Smart Paste

Paste data source from clipboard as table

Save View

Save data source as view

GroupIconDescription

Display

Show/ Hide Design Panel.  

Pause Refresh

Activate/deactivate automatic refresh after each navigation step in the Design Panel.