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.
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.
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.
This section contains all fields that are currently displayed in columns.
This section contains all fields that are currently displayed in rows.
This section contains all fields that are currently defined as background filters.