Show TOC

The Analysis tabLocate this document in the navigation structure

On the Analysis tab, you can see the available fields for a single data source and the fields currently used to display the data in a crosstab in columns and rows. If you use multiple data sources in your analysis, select a crosstab cell of the required data source to specify which data source information should be displayed.

The Analysis tab contains the following sections:
  • Search field

    You can search for a numeric or character string. The search results are highlighted.

    In the sections Columns, Rows and Background Filter, the relevant nodes are expanded automatically.

    Due to performance reasons, the nodes in the <Data source> section are not expanded automatically. If you expand them manually, you can see the highlighted search results. By expanding the nodes manually, the data has been loaded and the nodes will be expanded automatically in future searches.

  • <Data source>

    The heading for this section is the name of the selected data source. You can check whether you have selected the right data source. The section displays all fields of the data source: measures, dimensions, attributes and hierarchies.

    You can move a data source field to another section on the Analysis tab to add it to the crosstab. If you move a field to another section, its name is displayed in both sections: the data source section and the other crosstab section, for example Rows. Attribute and hierarchy fields that are added to another crosstab section, are displayed in bold letters in the data source section.

    In Bex Query Designer, a dimension can be defined as not to be displayed. These dimensions are displayed in the Analysis design panel in gray font. You can add them to your crosstab and filter them. This will affect the data and result in your crosstab, but the dimensions will not be visible in the crosstab. If you want a dimension to be displayed in an Analysis crosstab, you have to change the definition in BEx Query Designer.

  • Columns

    This section contains all fields that are currently displayed in columns.

  • Rows

    This section contains all fields that are currently displayed in rows.

  • Background Filter

    This section contains all fields that are currently defined as background filters.

Navigating through the data
Using the Analysis tab, you have the following options to analyze data and create new views on it:
  • You can use the context menu to move fields in the four sections. You can add a new dimension from the <Data source> section to the Rows, for example.
  • You can use drag and drop to move fields in the four sections.
  • You can use drag and drop to add rows and columns to the crosstab. Drag a field directly to the crosstab and drop it. The field is added automatically to the corresponding section on the Analysis tab.
  • You can also use drag and drop to remove a field from the crosstab. Select the border of a cell in the crosstab to drag the field to the Analysis tab and drop it there.
  • You can use the context menu to create, change and remove filters. If a filter is defined for an object, you see a filter icon beside this object.