The Design Panel

 

Analysis Tab

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:

  • The pane 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 :

  1. Select the table you want to change (Ex : Crosstab 1).
  2. In the properties, click on "Repeat Members"

Result :

 

How to stop BW from changing my column width after each refreshing ?

  1. Click the crosstab that you are working on.
  2. Uncheck "Optimum Cell Width/Height".

Then the column width will be already as you drag and will not be changed by a refreshing.

 

 

Deleting or copying a data source / table from the workbook

You can delete an existing data source or table via the component tab :

  1. Select the Datasource or Crosstable
  2. Right click and select Delete or Copy
  3. If Copy, it will prompt for a destination cell