In this article:
Setting Up Dimensions and Element Selection
Selecting Dimension Layout Option in Table
The Reports, Analytical Queries (OLAP) and Dashboards tools use data of one or several multidimensional sources.
A dimension is a structural unit of a multidimensional data source. Repository dictionaries are used as dimensions.
To work with data source dimensions, the Selection tab group on the side panel is intended.
For the Analytical Queries (OLAP) and Dashboards tools:
To facilitate work with a number of dimensions, dimensions with selection are highlighted with gradient in the list of dimensions on the side panel, and solid color highlighting is also used in the drop-down list of dimensions.
NOTE. To work with the Reports tool in the web application, see the Getting Started with the Reports Tool in the Web Application article.
Selecting a fixed dimension as a metric for the table enables the user to set up the view for several dimension elements using font color and size or cell fill. Specify dimensions to be displayed in table rows or columns and dimensions to be excluded from rows and columns, that is, will be fixed. By changing the dimension layout it is possible to find the best match view of the data to be analyzed.
Select dimension layout option in tab menu in the Selection side panel group of tabs, clicking the button with the , or icon which is located to the left from tab title:
By Columns.
By Rows.
Fixed.
Fixation of dimension is used to hide dimension from table rows and columns based on which data views are built.
Filter in Source. The option is available in the Analytical Queries (OLAP) and Dashboards tools.
NOTE. It is available only for cubes with enabled fact aggregation method.
Use the Filter in Source position option for the dimensions that will be used in creating a data view.
When source cubes with enabled dimension aggregation method are added to express report or dashboard, the Filter in Source position option is used by default, if dimensions are excluded from rows and columns. If aggregation is disabled in the cube, the Fixed position option is applied for these dimensions.
NOTE. When express report or dashboards are opened in the desktop application, the Fixed position option is applied for the dimensions that use the Filter in Source position option.
The order of dimension layout on the Selection tab group of the side panel depends on the layout option selected for this dimension. Above are located dimensions in columns, next - in rows, below - fixed.
For visualizers, the dimension role is set instead of dimension layout in tab menu of the Selection side panel group of tabs:
The dimension elements with the Metrics role can manage visualizer characteristics, for example, for the table it is possible to set value, background color, font color, font size. Additional radio buttons are displayed on the dimension tab. The set of radio buttons depends on the visualizer type:
A detailed description is given in the Setting Up Dimension Role article.
Combination of dimensions merges several dimensions into one and displays its elements as a time series tree. To combine dimensions, click the Combine button on the Hierarchy ribbon tab.
NOTE. Combination of dimensions is available in the Dashboards and Analytical Queries (OLAP) tools.
A detailed description is given in the Combining Dimensions article.
Dimension editing is designed for custom dimension setup and provides a possibility to edit:
To set up source dictionary parameters, open the dictionary setup wizard.
NOTE. Source dictionary parameters can be set up only in the desktop application.
To do this:
Select the Dimension > Source Dictionary item in the dimension's context menu.
Click the Edit button in the Dimension group on the Hierarchy ribbon tab. Then select the Source Dictionary item in the drop-down menu of the button. The Hierarchy tab is available after the Selection side panel tab is selected.
NOTE. Source dictionary parameters setup can be disabled by means of the Fore language.
The dimension can be edited if primary key is determined in all cube dimensions.
A detailed description is given in the Editing Dimensions article.
The following operations are available when working with dimension elements:
Dimension search. The option is available in the web application in the Analytical Queries (OLAP) and Dashboards tools.
Changing displaying of element names.
For detailed description, see the Working with Dimension Elements article.
Alternative hierarchy presents alternative rules, by which elements are grouped in dimension. Alternative hierarchy enables the user to display the same data in various aspects.
A custom hierarchy is a type of alternative hierarchy obtained after editing a list of dimensions and/or dimension element.
The following operations are available on working with hierarchies:
For detailed description, see the Working with Hierarchies article.
See also: