Specifying level-specific formats of data in hyperblocks

You can format the value cell of a hyperblock so that data output is formatted according to its level in the hierarchy. To do this, use the GETLEVEL function.

See GETLEVEL.

To format the Key Output cell see this topic:

Creating a style for a level.

Place a hyperblock on the spreadsheet, right-click the value cell, and select Conditional Formatting. In the Condition section, select Formula is from the list. The GETLEVEL function has this syntax:

GETLEVEL(reference of the key output cell)=n

where n is one of the levels of the hierarchy.

Example

To format the data in a hyperblock according to its level in a hierarchy:

  1. Select cells C6:D6 in Design Mode.
  2. Drag a dimension or list from the Database Structure and drop it on cell C6.
  3. A hyperblock is created in cells C6:D6.
  4. Create an OLAP formula in cell D6

    See Edit OLAP Formula wizard.

  5. Right-click D6 and select Conditional Formatting.
  6. Create a formula condition where the formula is GETLEVEL($C$6)=1.

    See Specifying conditional formatting.

  7. Create further GETLEVEL conditions for each level of the hierarchy (using the correct level number for each). Apply a different format to each condition.
    In View Mode, data is formatted according to its level in the hierarchy.
    Note: You can format elements, as well as data, according to their level in a hierarchy by specifying a fill style in the Hyperblock Output Properties dialog

    See Creating a style for a level.