The INDENT command shifts the first row names column in column-output order by the specified number of characters.
{ INDENT [ offset ] }
offset | Optional. Number of spaces to indent column 0 from the left boundary
of the name column. Values:
|
Default (No value): Indents columns by 2.
When a member is indented, the width of the names column for that member is decreased to offset the indent. This does not shift the remaining columns in the report.
Once the indented names column has been declared, you can use the ORDER command to moved it within the final output format or precede it with regular or calculated columns.
Hierarchical relationships between row members are, by default, indicated by indentation. Indentation only applies to a group of rows generated together, such as when a single ! is used. If each consecutive row is generated independently, using its own !, then no indentation occurs.
In the following example, the first report for Chicago shows the default indentation while the second report for Boston uses the { INDENT 10} command to shift the row names column 10 places to the right.
<PAGE (Market, Accounts, Scenario) Chicago Sales Actual <COLUMN (Year) <ICHILDREN Year <ROW (Product) <ICHILDREN Audio ! { INDENT 10 } Boston Sales Actual <ICHILDREN Year <ICHILDREN Audio !This example produces the following report:
Chicago Sales Actual Qtr1 Qtr2 Qtr3 Qtr4 Year ======== ======== ======== ======== ======== Stereo 2,591 2,476 2,567 3,035 10,669 Compact_Disc 3,150 3,021 3,032 3,974 13,177 Audio 5,741 5,497 5,599 7,009 23,846 Boston Sales Actual Qtr1 Qtr2 Qtr3 Qtr4 Year ======== ======== ======== ======== ======== Stereo 2,450 2,341 2,377 2,917 10,085 Compact_~ 3,290 3,034 3,132 3,571 13,027 Audio 5,740 5,375 5,509 6,488 23,112
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.