You can report on the data in a database using the following methods:
Report Script Editor. Use Report Script Editor to create large-scale reports comprising many pages of multidimensional data. Reports of this scale often can exceed the capabilities of even the most robust spreadsheet. Report Writer commands let you define formatted reports, export data subsets from an Essbase database, and produce free-form reports. See “Creating Scripts” in the Oracle Essbase Administration Services Online Help.
Through a spreadsheet. Use report commands in a spreadsheet in free-form mode or template-retrieval mode. See the Oracle Essbase Spreadsheet Add-in User's Guide.
Essbase APIs. See Generating Reports Using the C, Visual Basic, and Grid APIs and see the Oracle Essbase API Reference.
For information about creating and editing report scripts in Administration Services, see “About Report Script Editor” in the Oracle Essbase Administration Services Online Help.