<COLUMN

Command

The COLUMN dimensions command specifies the column or columns to display across the page.

Syntax

<COLUMN ( dimList)

dimList Dimension name or a comma-delimited list of dimensions

Description

This command defines the dimensions that are displayed as column members in the final report. Column members are displayed above the data columns in the report. Any member in the report specification from the dimension the member in the COLUMN command is a column member. 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. You can have at most one member from each dimension in the dimList and cannot repeat a 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.

Example

<COLUMN (Year, Scenario)

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

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.

See Also

PAGE
ROW