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)
where dimensionName equals the name of each dimension to display across the page. For example:
<COLUMN (Year)
where dimensionName equals the name of each dimension to display down the page. For example:
<ROW (Market)
<PAGE (Product, Measures) <COLUMN (Scenario, Year) Actual <ICHILDREN Qtr1 <ROW (Market) <IDESCENDANTS East !
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 !
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