Setting Up Data Area Sidehead

Question

How to set up data area sidehead to show only leaf elements?

Application Area

A data area sidehead can use several dimensions, each dimension can have a separate hierarchy. If the dimension has a large hierarchy, it may require to display only leaf dimension elements for a more convenient sidehead display, that is, lower hierarchy level elements.

Source Data

Create a data area

The data area looks as follows:

The sidehead must display only leaf elements of the Territories dimension.

Solution

Adjust data area parameters. To do this:

1. Select any cell in this area and select the Data Area Parameters context menu item.

2. Go to the Layout > Rows > Dimension tab in the Data Area Properties dialog box.

3. Select the Territories dimension and select the Allocate only Leaf Elements checkbox for this dimension:

4. Do not select the Allocate only Leaf Elements checkbox for the Socio-Economic Indicators dimension.

5. Click the OK button to save settings.

6. Calculate the data area for the settings to apply.

After this the data area looks as follows:

Thus, the data area sidehead is set up to show only leaf elements of the Territories dimension.

See also:

Questions and Answers | Data Area | Data Area Properties