Creating a style for a level

Typically, elements in a list are organized in a hierarchy. For lists which are displayed in a hyperblock, you can specify a different format for the elements at each level of the hierarchy. For example, the Period dimension of the Analysis cube of the Best Practices sample database has four levels: All Years, Years, Quarters, and Months.

See Best Practices sample database.

To create a style for each level:

Create a hyperblock and select Format > Style
The Edit Styles dialog is displayed.

Note: The Style option is disabled if the hyperblock is currently selected. Click anywhere outside the hyperblock to deselect it.
Specify a style name, ending in a number which represents the level of the hierarchy. For example, Level1.
To specify a style name, overwrite the currently displayed style name.
Click Add
Click Change and define the style.
See Editing a style.
Add the style name for each level of the hierarchy, using a different number at the end of each (for example, Level2, Level3 and Level4). Specify a format for each level.
To assign the style to the key output cell, go to the Hyperblock Output Properties (Editing hyperblock output properties) dialog and select it in the Fill style list.

Note: In the Fill style list, the name of the style does not display the final, numeric character.

In View Mode, each level of the hierarchy has a different format. But, only the elements displayed in the Key Output cell are formatted. The values displayed in the Value cell are not formatted. The Fill Style option is not available in the Hyperblock Output Properties dialog of value cells. Instead, to assign level-specific formats to the value cell of a hyperblock use the GETLEVEL function in a conditional format. An example is given in this topic:

Specifying level-specific formats of data in hyperblocks.