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. This script is based on the Sample.Basic database.

  1. Create a report script.

    See “Creating Scripts” in the Oracle Essbase Administration Services Online Help.

  2. 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
    !
  3. Save the report script.

    See “Saving Scripts” in the Oracle Essbase Administration Services Online Help.

  4. Execute the report script.

    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