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 ...

Get Oracle Essbase 9 Implementation Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.