The Design Panel

  By clicking the arrow below the Display Icon, you access 2 more options which will open new panels :

to display Property view of an object

to display technical Names  of the whole objects .

                

 

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 together with the properties of these components.

You can select if the components should be listed by data source or by sheet.

In both cases, the highest node of the list is the workbook. Below this, the data sources or the sheets are displayed with their components.
You can use the context menu to manage the 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. either In the properties, click on "Repeat Members" or open the right arrow of the îcon Crosstab to get the corresponding option and then click on.

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