SKIPONDIMENSION

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

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 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
   !

This 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