Create Report Scripts

Report scripts generate formatted data reports on an Essbase cube. A report script consists of a series of commands. You can use the Essbase web interface to write scripts to generate large-scale reports that consist of many pages of multidimensional data.

Reports of this scale often exceed the capabilities of even the most robust spreadsheet. In report script editor, you use report commands to define formatted reports, export data subsets from a database, and produce free-form reports. You can then execute the script to generate a report.

To learn how to write report scripts, refer to Report Writer for syntax and examples.

  1. On the Home page, open the application and then open the database (cube).

  2. Click Scripts, and then click Report Scripts.

  3. Click Create.

  4. In the New Report Script field, enter a name for the report script.

  5. In the editing pane, enter the report script contents, or copy and paste it from a text editor.

  1. On the Applications page, expand the application.
  2. From the Actions menu, to the right of the cube name, launch the inspector.
  3. Select the Scripts tab, and then select the Report Scripts tab.
  4. Click Add Image of the Add icon.to create a new report script.
  5. In the Script Name field, enter a name for the report script.
  6. In the editing pane, enter the report script contents, or copy and paste it from a text editor.