Column Dimensions

Data source types: Oracle Essbase, Oracle Analytics Cloud - Essbase

Column Dimensions Interpreted as Page Dimensions

When there is one row dimension and multiple members, all of different dimensions, in the same top row, the left-most dimension in the row is treated as column dimension and the others as page dimensions. Figure 23-7 shows a valid grid in which Year is the row dimension, Measure is the column dimension, and Product and Market are page dimensions.

Figure 23-7 Column and Page Dimensions in the First Row


Shows a valid grid as described in the previous paragraph.

The first members of each column dimension must occur on the same column, and the first members of every row dimension must occur on the same row. Figure 23-8 is invalid because cell B2 is on the first column of the column dimensions and must be a member of the Measures dimension, whereas it is a comment.

Figure 23-8 Invalid Placement in Column


Shows a grid that is invalid for the reason described in the previous paragraph.