SKIPONDIMENSION
The Essbase Report Writer SKIPONDIMENSION command 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 }
Parameters
Notes
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. 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 following report script is designed for the Demo Basic cube, available in the gallery. The command {SKIPONDIMENSION Year}
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
!
The above report script example produces the following report:
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