Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »


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 :

 

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

 

The best way to get IT support is to use the new Service One Platform.