When you combine report commands that include page, row, and column dimension declarations with selected members, you have all the elements of a simple report script.
The following step-by-step example of the report script process includes a sample script that specifies these elements, dimensions, and member selection commands. It includes comments, which document the behavior of the script, and the ! output command. This script is based on the Sample.Basic database.
See “Creating Scripts” in the Oracle Essbase Administration Services Online Help.
Type the following information in the report script.
// This is a simple report script example // Define the dimensions to list on the current page, as below <PAGE (Market, Measures) // Define the dimensions to list across the page, as below <COLUMN (Year, Scenario) // Define the dimensions to list down the page, as below <ROW (Product) // Select the members to include in the report Sales <ICHILDREN Market Qtr1 Qtr2 Actual Budget Variance <ICHILDREN Product // Finish with a bang !
See “Saving Scripts” in the Oracle Essbase Administration Services Online Help.
See “Executing Report Scripts” in the Oracle Essbase Administration Services Online Help.
When you execute the example script against the Sample.Basic database, it produces the following report:
East Sales
Qtr1 Qtr2
Actual Budget Variance Actual Budget Variance
======== ======== ======== ======== ======== ========
100 9,211 6,500 2,711 10,069 6,900 3,169
200 6,542 3,700 2,842 6,697 3,700 2,997
300 6,483 4,500 1,983 6,956 5,200 1,756
400 4,725 2,800 ,925 4,956 3,200 1,756
Product 26,961 17,500 9,461 28,678 19,000 9,678
West Sales
Qtr1 Qtr2
Actual Budget Variance Actual Budget Variance
======== ======== ======== ======== ======== ========
100 7,660 5,900 1,760 7,942 6,500 1,442
200 8,278 6,100 2,178 8,524 6,200 2,324
300 8,599 6,800 1,799 9,583 7,600 1,983
400 8,403 5,200 3,203 8,888 6,300 2,588
Product 32,940 24,000 8,940 34,937 26,600 8,337
South Sales
Qtr1 Qtr2
Actual Budget Variance Actual Budget Variance
======== ======== ======== ======== ======== ========
100 5,940 4,100 1,840 6,294 4,900 1,394
200 5,354 3,400 1,954 5,535 4,000 1,535
300 4,639 4,000 639 4,570 3,800 770
400 #MISSING MISSING #MISSING #MISSING #MISSING #MISSING
Product 15,933 11,500 4,433 16,399 12,700 3,699
Central Sales
Qtr1 Qtr2
Actual Budget Variance Actual Budget Variance
======== ======== ======== ======== ======== ========
100 9,246 ,500 2,746 9,974 7,300 2,674
200 7,269 6,800 469 7,440 7,000 440
300 10,405 6,200 4,205 10,784 6,800 3,984
400 10,664 5,200 5,464 11,201 5,800 5,401
Product 37,584 24,700 12,884 39,399 26,900 12,499
Market Sales
Qtr1 Qtr2
Actual Budget Variance Actual Budget Variance
======== ======== ======== ======== ======== ========
100 32,057 23,000 9,057 34,279 25,600 8,679
200 27,443 20,000 7,443 28,196 20,900 7,296
300 30,126 21,500 8,626 31,893 23,400 8,493
400 23,792 13,200 10,592 25,045 15,300 9,745
Product 113,418 77,700 35,718 119,413 85,200 34,21