## 4.1.1  The Analysis tab
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 &lt;Data source&gt; 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.
## · &lt;Data source&gt;
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 . Dimension, 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. In SAP BW and SAP HANA systems, you can group dimensions in data sources, for example, grouping all dimensions containing geographical information. In Analysis, you can decide if the dimensions of a data source are displayed as a flat list or as grouped dimensions. You can change the display by choosing
Display Show Dimension Grouping in the ribbon. The selected display remains until you change it again, even if you leave Excel meanwhile.
## · Columns
This section contains all fields that are currently displayed in columns.
## · Rows
This section contains all fields that are currently displayed in rows. Next to the section header, you can select the Swap Axes icon to swap rows and columns.
## · Background Filter
This section contains all fields that are currently defined as background filters.
## · Properties
In this section, you can define properties for the data source, measures and dimensions. You can show or hide this section by choosing Display Show Property View in the design panel group.
## 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 &lt;Data source&gt; 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.
- You can swap the axis of the crosstab by selecting the icon next to the rows section.
## Related Information
The Property View on the Analysis tab [page 145]