Report scripts generate formatted data reports on a database. 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.
You can type the contents of a report script directly into the text area of Report Script Editor, or you can use the user interface features of the script editor to build the script. Report scripts are text files. If desired, you can create a report script in the text editor of your choice and paste it into Report Script Editor.
You can associate a report script with a specific database or with all databases in an application. In Enterprise View, a container node for report scripts appears under each application and each database that contains at least one existing script. If no scripts are defined for an application or database, the container node is not displayed. Report scripts are given a .rep extension by default. From Administration Services Console, you can view and execute only report scripts that have the .rep extension.
For more information about developing report scripts, see the Oracle Essbase Database Administrator's Guide. For information about report commands, see the Oracle Essbase Technical Reference.
“Developing Report Scripts” in the Oracle Essbase Database Administrator's Guide
“Optimizing Reports and Other Types of Retrieval” in the Oracle Essbase Database Administrator's Guide