Creating Page, Column, and Row Headings

  To define report headings:

  1. Enter <PAGE(dimensionName, dimensionName)

    where dimensioNname lists dimensions represented on the current page. All data values on the page have the dimensions in the page heading as a common property. Example:

    <PAGE (Measures, Market)
  2. Press Enter.

  3. Enter <COLUMN(dimensionName)

    where dimensionName equals the name of each dimension to display across the page. For example:

    <COLUMN (Year)

    Adding dimension names creates nested column headings.

  4. Press Enter.

  5. Enter <ROW(dimensionName)

    where dimensionName equals the name of each dimension to display down the page. For example:

    <ROW (Market)
  6. Press Enter.

    Note:

    You can select additional members to associate with the heading commands. Using a member name as a parameter for the PAGE, COLUMN, or ROW commands causes Report Extractor to associate the member with the appropriate dimension.

Example report script:

<PAGE (Product, Measures)
<COLUMN (Scenario, Year)
Actual
<ICHILDREN Qtr1
<ROW (Market)
<IDESCENDANTS East
    !

Resulting report:

              Product Measures Actual

                      Jan       Feb       Mar      Qtr1
                 ========  ========  ========  ========
New York              512       601       543     1,656
Massachusetts         519       498       515     1,532
Florida               336       361       373     1,070
Connecticut           321       309       290       920
New Hampshire          44        74        84       202
  East              1,732     1,843     1,805     5,380

You can create page, column, and row headings with members of attribute dimensions.

Example report script:

<PAGE (Measures,Caffeinated)
Profit
<COLUMN (Year,Ounces)
Apr May
"12"
<ROW (Market,"Pkg Type")
Can
<ICHILDREN East
    !

Resulting report:

           Profit Caffeinated 12 Scenario
                            Apr       May
                       ========  ========
New York         Can        276       295
Massachusetts    Can        397       434
Florida          Can        202       213
Connecticut      Can        107        98
New Hampshire    Can         27        31
  East           Can      1,009     1,071