Sample 1: Creating a Different Format for Each Page

This Essbase report script generates a report for each page member.

This sample report contains data for Actual Sales. Each report page shows a different Product. The report lists products on the same page until the maximum page length is reached. To place each Product on a separate page, you must use the PAGEONDIMENSION format command, as shown in Sample 2: Handling Missing Values.

Because none of the cities in South sell Stereo or Compact_Disc, the data values indicate #MISSING. You can represent missing values by suppressing the row or substituting a replacement text string, such as N/A. See Sample 2: Handling Missing Values for an example of substituting page breaks and labels for missing values.

                          Sales Actual Stereo

                             Qtr1     Qtr2     Qtr3     Qtr4
                         ======== ======== ======== ========
East                        7,839    7,933    7,673   10,044
West                       11,633   11,191   11,299   14,018
South                    #Missing #Missing #Missing #Missing
Market                     19,472   19,124   18,972   24,062

                              Sales Actual Compact_Disc

                             Qtr1     Qtr2     Qtr3     Qtr4
                         ======== ======== ======== ========
East                       10,293    9,702    9,965   11,792
West                       14,321   14,016   14,328   17,247
South                    #Missing #Missing #Missing #Missing
Market                     24,614   23,718   24,293   29,039

                                  Sales Actual Audio

                             Qtr1     Qtr2     Qtr3     Qtr4
                         ======== ======== ======== ========
East                       18,132   17,635   17,638   21,836
West                       25,954   25,207   25,627   31,265
South                    #Missing #Missing #Missing #Missing
Market                     44,086   42,842   43,265   53,101

Use the following script to create Sample 1:

<PAGE (Accounts, Scenario, Product)
Sales
Actual
<IDESCENDANTS Audio

    <COLUMN (Year)
    <CHILDREN Year

<ROW(Market)
<ICHILDREN Market
    !

The ! report output command is required to generate the report.

Because the IDESCENDANTS selection command is used for Audio, the report selects all three members. Only a single member is selected from the other page dimensions, Sales and Actual. As a result, the script creates three report pages. They display as one long report page unless you use the PAGEONDIMENSION format command, as shown in Sample 2: Handling Missing Values.