Lesson: Repeating Member Labels

By default, Essbase displays member labels once for each nested row and column group.

You can repeat member labels in each row or column cell that represents a data point, so that you can always see a member label in the worksheet view. This feature is helpful for keeping track of member labels when scrolling through large worksheets.

  To repeat member labels down and across the worksheet:

  1. Select Essbase, and then Options.

  2. In Display, under Aliases, clear Use Both Member Names and Aliases for Row Dimensions.

  3. In Cells, select Repeat Member Labels, and then click OK.

  4. In cell E1, drill down (double-click) on Year.

    Essbase displays a member label in every column and row cell.

    Result of repeating member labels.
  5. Before continuing the tutorial, complete these actions:

    1. Select Essbase, and then Options.

    2. In Display, under Cells, clear the Repeat Member Labels, and then click OK.

    3. Select File, and then Close.

      Do not save the worksheet.

User Reference

Repeating Member Names