Data source types: Essbase
When working with stacked dimensions in an ad hoc grid, and the Suppress Repeated Members option is selected, Essbase“centers” the member label above the labels in the previous row, up to the first row dimension. An example scenario follows.
Using the Sample Basic database, select the Ad hoc analysis option. The Measures, Product, Market, Scenario, and Year dimensions are retrieved on the worksheet as shown in Figure 14, Sample Basic Initial Ad Hoc Analysis Grid.
Arrange the dimensions so that there are three “stacked” dimensions and two dimensions side by side, according to Figure 15, Sample Basic Grid with Dimensions Arranged in a Stacked Configuration.
By default, in the Data tab of the Options dialog box, the Repeated Members option in the Suppress Rows group is cleared. Zoom in on the Product and Year members, then zoom in on the Market and Scenario dimensions. The resulting grid looks similar to Figure 16, Zooming in on the Dimensions in the Grid Before Selecting the Repeated Members Option.
Note: | For ease of reading, the South and Central members were removed from the grid in Figure 16, Zooming in on the Dimensions in the Grid Before Selecting the Repeated Members Option and Figure 17, Refresh the Grid After Selecting the Repeated Members Option. |
Now, from the Smart View ribbon, select Options, then select the Data tab. In the Suppress Rows group, select the Repeated Members options. Then refresh the sheet. The resulting grid looks similar to Figure 17, Refresh the Grid After Selecting the Repeated Members Option. For each of the row dimensions, the member label is centered above the labels in the previous row.
