Displaying and Suppressing Repeated Members
Data source types: Oracle Essbase, Oracle Analytics Cloud - Essbase
This topic describes using the Repeated Members option in the Options dialog box, Data Options tab, Suppress Rows group. This option only applies to Essbase data sources. To use the other data suppress options in the Suppress Rows and the Suppress Columns group, see Data Options.
When working with stacked dimensions in an ad hoc grid, and the Suppress Repeated Members option is selected, Essbase positions the suppressed member label above the labels in the next row, up to the first column dimension, using the "proximity rule". With the proximity rule, when repeated members are suppressed, Essbase compares the stacked dimensions row by row. It groups the non-repeating, unsuppressed members under the closest suppressed member in the previous row. Essbase can then determine which member is being queried and retrieves the data accordingly.
The scenario that follows shows the proximity rule in action.
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 6-11.
Figure 6-11 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 6-12.
Figure 6-12 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 6-13.
Figure 6-13 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 6-13 and Figure 6-14.
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 6-14. For each of the column dimensions in rows 1 and 2, where there were suppressed repeated members, the member label is centered above the labels in the next row.
The data in columns C, D, E, F, and G belong to the East member; the data in columns H, I, J, K, and L belong to West. Using the proximity rule, Scenario in column G belongs to East because it is only two columns from the East member, but three columns from the West member.
The Measures dimension label applies to the entire grid.
Figure 6-14 Refresh the Grid After Selecting the Repeated Members Option
