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 }
Parameter | Description |
---|---|
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
See Also