SAP BO Analyses - SAP BO Analysis Edition For OLAP

What is SAP BO Analyses?

You can link to a data source and additionally examine the data by means of features in the tool In Analysis Edition for OLAP. You can add a crosstab and charts as well as drag the objects from the data source to examine the data.

Every analysis workspace comprises numerous sheets; it is independent from each other. Analysis stores the structure of data and chart, and the crosstab is used to show the data in the workspace. An Analysis can be showed by means of different types of mechanisms - Charts or Crosstabs.

When an analysis comprises a crosstab and chart they are measured as linked with each other. When the data in crosstab is updated, it also updates the data in the chart mechanically.

Defining a New Analysis

By making use of hierarchy or any level of hierarchy you can add a new analysis. To build a new analysis, drag the hierarchy from the data panel to the layout panel.

  • You can drag it to the "Rows" area if you want to add the selected hierarchy to the crosstab's rows,.
  • Drag it to the "Columns" area if you want to add the selected hierarchy to the crosstab's columns,
  • Drag it to the "Background" filter area if you want to add the hierarchy to the crosstab's background filter.


You have an auto update choice on the top right corner of the analysis. When automatic update is on, it updates the crosstab and chart mechanisms with each hierarchy to the Layout panel, make happen short delays.

You can also turn off automatic update by clicking the Auto Update button.


Few Points to be measured around Analysis

  • You can’t add members from the similar hierarchy to two axes.
  • You can’t use hierarchies of the same dimension in the same analysis when you are using SAP BW as the data source.

When a data source is carefully chosen in a new workspace, an analysis is automatically created. You can add an analysis to the workspace in the resulting ways −

  • When you add a crosstab to the sheet, by default, adding a new crosstab generates a new analysis. The new analysis is linked to the data source that is presently selected on the Data panel.
  • Add a new data source to the workspace, and then add a crosstab to the sheet. The new analysis is linked to the new data source.
  • Add another crosstab or chart module to the sheet as a sub-analysis. The sub analysis is linked to the new analysis, but you can unlink the new component from the original analysis, creating a separate analysis.

Adding Analysis to a Worksheet

Click the Insert button in the tool bar and then click Insert Crosstab button to add an analysis to the current sheet to add an analysis. When you add a new analysis, it is linked to the presently selected data source and showed in the outline panel.

Note − It is also likely to add the crosstab as a sub-analysis, by clicking the arrow nearby the Insert Crosstab button.


You get a choice to insert one in the outline panel. When you click on insert a new analysis button, a new analysis is added when there is no analysis in the workspace.


To erase an Analysis, you have to click the delete button on the top right corner of the screen.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

SAP BO Analysis Edition For OLAP Topics