PAGEONDIMENSION

Performs a page break whenever a member from the same dimension as the specified member changes from one line in the report to the next.

Syntax

{ PAGEONDIMENSION mbrName }

Parameters

mbrName: Single member. If any member of the same dimension increments, a new page is started.

Notes

This command performs a page break whenever a member from the same dimension as the member in the command changes from one line in the report to the next.

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.

PAGEONDIMENSION causes a new page to begin when the member from the selected dimension changes. A single report can have several PAGEONDIMENSION commands to page on different dimensions which change.

When combined with UNAMEONDIMENSION and SKIPONDIMENSION, UNAMEONDIMENSION is processed first followed by SKIPONDIMENSION and PAGEONDIMENSION in order.

Example

The command { PAGEONDIMENSION Year } inserts a page break before displaying the members Qtr2, Qtr3, and Qtr4 in the following report below. On each new page, the heading members Chicago, Sales and Actual are displayed at the top of the page.

<PAGE (Market, Accounts)
Chicago Sales Actual

      <COLUMN (Scenario)
      <CHILDREN Year

<ROW (Year, Product)
{ PAGEONDIMENSION Year }
<ICHILDREN Audio
     !

This example produces the following report:

     Chicago Sales Actual 

Qtr1    Stereo      2,591 
      Compact_Disc  3,150 
      Audio         5,741
          

     Chicago Sales Actual 

Qtr2    Stereo      2,476 
      Compact_Disc  3,021 
      Audio         5,497

      Chicago Sales Actual 

Qtr3    Stereo      2,567
      Compact_Disc  3,032 
      Audio         5,599

      Chicago Sales Actual 

Qtr4    Stereo      3,035 
      Compact_Disc  3,974 
      Audio         7,009