Report Script in Essbase

This post provides fundamental information about working with report scripts to extract database information into reports.

Note: Replace "G" with "<" symbol

Working with a simple report script:

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. The script is based on the Sample Basic database, which is supplied with the Essbase Server installation.

• Create a report script.
  See “Creating Scripts” in the 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
  Gpage (Market, Measures)
  // Define the dimensions to list across the page, as below
  Gcolumn (Year, Scenario)
  // Define the dimensions to list down the page, as below
  

Grow (Product)
// Select the members to include in the report
Sales
Gichildren Market
Qtr1 Qtr2
Actual Budget Variance
Gichildren Product
// Finish with a bang
!

• Save the report script.
  See “Saving Scripts” in the Essbase Administration Services Online Help.
• Execute the report script.
See “Executing Report Scripts” in the 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    1,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