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:

  1. Do not select the Allocate only Leaf Elements checkbox for the Socially Economic Activities dimension.

  2. Click the OK button to save settings.

  3. 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