On the Analysis Tab of the Design Panel you can right click or drag and drop to add, remove, or re-order the dimensions and measures to be displayed in the crosstab:
Thepane of the left, shows the name of the associated data source, and displays all fields available from the data source, including measures, dimensions, attributes and hierarchies.
The Columns pane contains all fields that currently displayed as columns in the crosstab.
The Rows pane contains all fields that are currently displayed as rows in the crosstab.
The Background Filter pane contains all fields that are currently defined as background data filter. A background filter is a filter based on a field that is not currently displayed in the crosstab.
The Find feature highlights fields matching the search term that are found in the other panes.
Information Tab
On the Information Tab of the Design Panel you can choose to see details information about the entire workbook or a particular data source :
Data source Name
Key Date : Current date except for very specific reports.
Last Data Update : Date of the last data loading (Careful : Not always accurate in the case of queries build on Multi-Providers).
Variables : List of prompts and their values
Filter : Any filters applied in the report
Information : Identification of the datasource
Components Tab
On the Components Tab you can see a list of all components used in the workbook, and the properties of these components.
You can choose to list the components by data source or by sheet . You can also set options for selected components.
Repeating Members in the crosstab
By default BW reports will not repeat the "members" in the tables :
You can change this for each of the results via the Components tab :
Select the table you want to change (Ex : Crosstab 1).
In the properties, click on "Repeat Members"
Result :
Deleting or copying a data source / table from the workbook
You can delete an existing data source or table via the component tab :