Setting Up Data Source Structure

Setup of express report data source structure enables the user to set up dimensions available to work, and to set up names of attributes displayed in the presented data.

To set up data source structure use the Data Source Structure tab in the Structure and Parameters dialog box.

Click the Structure and Parameters button on the Data ribbon tab. The Structure and Parameters dialog box opens.

NOTE. The button is available if a data source is set for express report.

Go to the Data Source Structure tab.

To set up data source structure:

Use the Dimension column to select checkboxes next to the dimensions, which should be available for user in the Selection group of tabs on the side panel. The detailed description is given in the Showing or Hiding Dimensions in the Selection Tab Group section.
Dimensions with alternative hierarchies set are displayed as trees (tree is collapsed by default). In expanded tree dictionaries and dictionaries attributes used as alternative hierarchies are listed. The option is available if data source is:

Standard cube, which dictionaries attributes are used as alternative hierarchy.
The ADOMD cube, for dictionaries of which alternative hierarchy is set up.

Use the Selection Type column to set selection mode for calendar dimensions. To do this, click the calendar dimension name and choose selection type in the drop-down list:

By Elements Only. Only calendar elements are displayed on the Selection side panel tab.
By Levels Only. Only calendar elements are displayed on the Selection side panel tab.
By Elements and Levels. The Selection side panel tab displays calendar elements and levels.

NOTE. Changing the selection mode for calendar dimensions is available only for reports containing one data source.

If the Structure and Parameters dialog box is opened from report with several data sources, the Data Source Structure tab contains additional parameters:

Names of Data Sources in the Table. Selection or deselection of the checkbox provides a possibility to show or to hide names of data sources in the table. The checkbox is selected by default and data source s names are shown in the table.

Data Source. Select a data source, which dimensions will be shown in the Show Selected Dimensions Only list.