COLUMN

Defines the dimensions displayed as column members. Column members are displayed above data columns.

The order of the members in the command determines the order of the column headers in the report. The first header line of column members are from the same dimension as the first member in the dimList. The second line members are from the dimension of the second member, and so on. dimList can contain a maximum of one member from each dimension.

Once you have identified the column dimensions using this command, any members from those dimensions that are a part of the report are defined as the data columns. If a member is not selected from a column dimension, then the highest member in that dimension is used.

Syntax

<COLUMN ( dimList)

Parameters

dimList: Dimension name or a comma-delimited list of dimensions

Notes

If dimension names contain spaces or consist of numbers, they must be enclosed in double quotes.
When more than one dimension is specified, the first dimension in the list appears at the top of each column, the next dimension in the list appears lower on the page, nested below the first dimension, and so on.

Example

<COLUMN (Year, Scenario)

Creates a report with Year members at the head of each column. Nested below each Year member are columns headed by members of Scenario.