Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 3

changes.mady.by.user Jianglong Ji

Saved on

compared with

New Version Current

changes.mady.by.user ROLLIER, Charlotte

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2

The Design Panel

Image Removed

 

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:

1. You can show and hide the design panel by choosing Display >> Display Design Panel in the design panel group. You can modify the size and position of the design panel in Microsoft Excel. 


Image Added

2. On the Analysis tab, you can show and hide the property view on the design panel by choosing Display Show Property View .


Image Added

3. You can also show and hide the technical names in the design panel by choosing Display Show Technical Names in the design panel group. The technical names are displayed in squared brackets.


Image Added

4. Working with the design panel, the crosstab is updated after each navigation step. You can choose Pause Refresh to deactivate the permanent refresh.

Image Added


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. 

The Analysis tab contains the following sections:

  1. Search field: You can search for a numeric or character string. The search results are highlighted.
  2. Columns: This section contains all fields that are currently displayed in columns.
  3. Data source:  The section displays all fields of the data source:
The pane of the left, shows the name of the associated  data source, and displays all fields available from the data source, including
  1. measures, dimensions, attributes and hierarchies
.
  • The Columns pane contains all fields that currently displayed as columns in the crosstab.
    1. . 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. Attribute and hierarchy fields that are added to another crosstab section, are displayed in bold letters in the data source section.
    2. Rows: This section
    The Rows pane
    1. contains all fields that are currently displayed
    as
    1. in rows
    in the crosstab
    1. .
    The
    1. Background Filter
    pane
    1. : This section 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.
    1. filters.
    2. Properties: In this section, you can define properties for the data source, measures and dimensions. You can show or hide this section by choosing "Show Property" View in the design panel group.



    Image Added

    Using the Analysis tab, you have the following options to analyze data and create new views on it:

    1. You can use drag and drop to move fields in the four sections
    2. 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 Image Addedbeside this object.

    In the Property view on the Analysis tab, you can define properties for the data source, measures and dimensions in the workbook.

    Image Added

  • The Find feature highlights fields matching the search term that are found in the other panes.
    • Image Removed



    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
    Image Removed

    Image Added



    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 :

    Image Removed

    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 :

    Image Removed

    Image RemovedImage Removed

     

    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

     

    This is the initial customization for reports. If settings are changed will only be applied to versions saved in personal computer, core report published in server will not be changed.

    • Refresh Workbook on Opening: if marked will automatically refresh the report (without showing prompt).
    • Force Prompt for Initial Refresh: if marked the Prompt will appear when you open report
    • Store Prompts with Workbook: if marked will save the values in the Prompt
    • Remove Data Before Saving: if marked will delete all values from report. Next time the report is open will be empty.
    • Merge Variables: in case of several queries in the same workbook, if marked will merge prompt variables (if possible).

    Image Added




    Related Information

    Image Removed