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)| Parameter | Description |
|---|---|
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.
The maximum number of members in a dimension that is being specified for reporting on Hybrid Analysis is 255.
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.
See Also