1. Using Oracle Essbase
  2. Report on Data
  3. Create Report Scripts

Create Report Scripts

Report scripts generate formatted data reports on a cube. A report script consists of a series of Essbase report commands that define the layout, member selection, and format of a report.

Using report script editor, you can 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.

  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.