SAP BO Analysis Crosstabs - SAP BO Analysis Edition For OLAP

What is SAP Bo Analysis Crosstabs?

Data is examined in the form of a crosstab in Analysis edition for OLAP. A Crosstab is a grid table related to the spreadsheet. You have 3 axes for a Crosstab −

  • Row Axis − this displays dimensions or hierarchical values in OLAP data source.
  • Column Axis − this shows column data.
  • Background Filter − this is used to apply filters on the background value.

Adding a Crosstab

You can add a crosstab by dragging it from the obtainable chart type or you can add a crosstab by clicking the crosstab button in the tool bar.

add_crosstab

This adds the component to the right of a current window or below the current component. To display the data in the crosstab, you have to add a data source.

component

In a workspace, an vacant crosstab is located. To add the data, you add dimensions and hierarchies from the metadata explorer to the crosstab.

When you place one measure on the crosstab, the data is shown in the crosstab and you can then proceed to perform the analysis by adding different features available in the tool.

different_features

When you drag any of the dimension or hierarchy to the Background Filter, you will be stimulated to select the filter values.
You can enter the Separate selection or range selection, and selective values are imitated in Crosstab.

individual_selection

When the filters are applied, the values in the crosstab alter as per the background filter condition. In this instance, we have designated the background filter based on Employee #, and values are presented in the crosstab.

filter_condition

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

SAP BO Analysis Edition For OLAP Topics