Inserts a blank line when a member from the same dimension as the specified member changes on the next line in the report.
Syntax
{ SKIPONDIMENSION mbrName }
Parameter | Description |
---|---|
mbrName | Name of single member. When a member from this dimension changes during report processing, a blank line is inserted before the member change. |
Notes
This command outputs a blank line when a member from the same dimension as mbrName in the command changes on the next line in the report. With the ROW command, you can display members from several dimensions in columns on the side of the report. At least one member changes from one of these dimensions for each row of the report. The SKIPONDIMENSION displays a blank line before the member from the dimension changes. When combined with UNAMEONDIMENSION and/or PAGEONDIMENSION, UNAMEONDIMENSION is processed first followed by SKIPONDIMENSION and PAGEONDIMENSION in order.
Example
The command {SKIPONDIMENSION Year} in the following report inserts a blank line before the row members Qtr2, Qtr3, and Qtr4 in the report.
<PAGE (Market, Accounts) Chicago Sales <COLUMN (Scenario) Actual <ROW (Year, Product) { SKIPONDIMENSION Year } <CHILDREN Year <ICHILDREN Audio ! Chicago Sales Actual Qtr1 Stereo 2,591 Compact_Disc 3,150 Audio 5,741 Qtr2 Stereo 2,476 Compact_Disc 3,021 Audio 5,497 Qtr3 Stereo 2,567 Compact_Disc 3,032 Audio 5,599 Qtr4 Stereo 3,035 Compact_Disc 3,974 Audio 7,009
See Also