PAGEONDIMENSION
The Essbase Report Writer PAGEONDIMENSION command 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
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.
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, changing dimensions.
When combined with UNAMEONDIMENSION and SKIPONDIMENSION, UNAMEONDIMENSION is processed first, followed by SKIPONDIMENSION and PAGEONDIMENSION, in that order.
Example
In the following report script example, the command { PAGEONDIMENSION Year } inserts a page break before displaying the members Qtr2, Qtr3, and Qtr4. 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