Alternative Hierarchy Based on Dictionary Attributes

Dictionary attribute can be used as an alternative hierarchy. This enables the user to build a report by using dictionary attribute values as separate dimensions displayed in the Selection group of tabs.

To set up attribute as an alternative hierarchy:

1. Open a dictionary in the edit mode.

2. Set up a dictionary:

• In the table MDM dictionary/composite table MDM dictionary:

1. Add a unique or non-unique key of the attribute that is planned to use as an alternative hierarchy.

2. Go to the Description tab. Select the attribute and click the Edit button or select the same item in the attribute's context menu. The Attribute Properties dialog box opens. Select the Alternative Hierarchy checkbox.

NOTE. The Alternative Hierarchy and Multiple Values Allowed checkboxes cannot be selected at the same time.

• In table dictionary:

1. On the Structure wizard page add index by the attribute that is planned to use as an alternative hierarchy.

2. Go to the Attributes page. Select the attribute and click the Edit button or select the same item in the attribute's context menu. The Attribute Properties dialog box opens. Select the Alternative Hierarchy checkbox.

• In calendar dictionary:

1. On the Attributes page add a custom attribute used as an alternative hierarchy.

2. Select the added attribute and click the Edit button or select the same item in the attribute's context menu. The Attribute Properties dialog box opens. Select the Alternative Hierarchy checkbox.

3. Specify the attribute used as an alternative hierarchy. The order of actions differs for different Prognoz Platform 9 tools:

• For the Reports tool:

1. Open the Parameters dialog box.

2. Go to the Data Source Structure tab.

3. Select checkboxes next to the dimension attributes, which values must be used as an alternative hierarchy.

• For the Analytical Queries (OLAP) and Dashboards tools: open the Structure and Parameters dialog box.

1. Go to the Data Source Structure tab.

2. Select checkboxes next to the dimension attributes, which values must be used as an alternative hierarchy.

Example of Using Alternative Hierarchy based on Dictionary Attributes

Consider the express report, which data source is a cube. The cube contains the Socio-Economic Facts dimension. The Measurement Units attribute of this dimension is set as an alternative hierarchy.

Open the Structure and Parameters dialog box. Select the checkbox next to the Measurement Units attribute on the Data Source Structure dictionary.

The Selection group of tabs of the side panel displays the Socially Economic Indicators.Units dimension built by values of the Measurement Units attribute.

As a result, get the report, in which values of the specified dictionary attribute are used:

See also:

Dictionary Hierarchy | Alternative Hierarchy based on Dictionaries