Repeating Member Names

By default, Essbase displays member labels once for each set of data, which can be inconvenient, especially if the report is large. Essbase provides a way to repeat the member labels for each cell.

To repeat member names for column and row dimensions in each cell representing a data point:

Select Essbase, and then Options.
In Essbase Options, select Display.
Under Cells, select Repeat Member Labels.
Click OK.

Cola is repeated in rows 2 through 9 of column A.

Notes:

Essbase retains the repeated members in the worksheet even if you clear Repeat Member Labels. To suppress the repeated members from displaying in the worksheet, perform one action:
Clear Repeat Member Labels and open another worksheet.
Clear Repeat Member Labels, pivot the repeated members, and pivot the members again.
If you did not perform another action since you retrieved, you can use the FlashBack command to return to the previous view before applying the Repeat Member Labels feature.