Executing report scripts using MaxL
In this recipe, we will create a simple report script that we will use to extract data from the Sample2.Basic
database. You should complete the Setting up folder structure and other files needed for MaxL automation and Executing Dimension Build Rules using MaxL in this chapter as we will need the AUTOMATION
folder structure and the dimensions built.
Getting ready
To get started, click on the Start menu and Program | Oracle EPM System | Essbase | Start Administration Services Console. In the Log in menu, enter your Administration Server, Username, Password, and click on the Log in button.
How to do it...
Drill down on the Essbase Server in EAS, expand the Applications node, drill down on the Sample2 application, and right click on the Basic database. In the drop-down menu click Create and select Report Scripts.
In the Report Script editor, click on the Check Syntax button, click on File, click on Save, in the File Name textbox enter Rpt, and click on OK.
{ SUPCOMMAS...