O'Reilly logo

Oracle Essbase 9 Implementation Guide by Joseph Sydney Gomez, Sarma Anantapantula

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database components

Let's now go through some of the most important components in every database.

  • The database outline
  • Linked Reporting Objects
  • Partitions
  • Calculation scripts
  • Report scripts
  • Rules files

The database outline

The database outline defines the structure of the multi-dimensional database, including its hierarchies, member formulas, and child to parent consolidations (data rollups).

Once a database is created, an Essbase outline is also created with the same name. This file is saved on the Essbase server with the .otl extension. In the next chapter, we talk in-depth about the Essbase outline.

Linked Reporting Objects

Using the Linked Reporting Objects (LRO), you can attach an object to a cell. For instance, you could have a flowchart attached ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required