Databases Reference
In-Depth Information
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 to a specific value in a cell
alerting the user when the value was requested.
This object can be any of the following items:
• Cell note
• An externally created ile like Microsoft Word, an image, or another
Microsoft Excel file
• URL
• Another Essbase database
Partitions
Simply put, a partition is a slice of information from one database that is shared
with another database. There are three options for partitioning data in Essbase.
•
Transparent partition
: Allows the users to access data from the source
database as though it were stored in the target database. The source can be
another database in another application or even on another Essbase server.
•
Replicated partition
: Is a copy of a slice of data from the source database
that is stored in the target database.
•
Linked partition
: A linked partition points users from a cell in one database
to a cell in another database. A linked partition can give users a different
perspective of the data.
We will talk more about Essbase partitions in Chapter 8.
