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