24 Report on Data

Report writer is a text-based script language that you can use to report on data in cubes. You can combine selection, layout, and formatting commands to build a variety of reports.

With report writer, you can generate reports whose length or specialized format exceed the capabilities of some grid clients.

Report scripts generate formatted data reports from a cube. Using report script editor, you can create report scripts that specify exactly how you want to report on data. A report script consists of a series of Essbase report commands that define the layout, member selection, and format of a report.

To execute a report script, you must have read or higher access level to all data members specified in the report. Essbase filters any member from the output for which you have insufficient permissions.

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.

Execute Report Scripts

After creating and saving report scripts, you can execute them in the script editor to report on data loaded in your cube.

  1. Create your report script, upload an existing report script, or select one from the gallery.
  2. On the Applications page, expand an application, and select a cube.
  3. From the Actions menu, to the right of the cube name, launch the inspector.
  4. Select Scripts, and select Report Scripts.
  5. Select the report script you want to run.
  6. Click Execute.
  7. Download or print the report output.