Databases Reference
In-Depth Information
Step 6: Select Dimension build method
Build dimensions methods are basically used for adding, removing, or updating
a member, an alias, or a property of an Essbase outline member. These are defined
in the build rule files.
There are three ways you can build an Essbase outline:
• Generation reference
• Level reference
• Parent-child reference
Let us talk about how each method can be used to update the Essbase outline.
Generation reference
With the generation reference set, the data source should be arranged or organized
from top to bottom as it pertains to the database outline structure. We consider the
dimension name itself as
Generation 1
. Each record in the rules file contains the
parent name as
Generation 1
, the child names are
Generation 2
, children of the
child name are
Generation 3
, children of that child name are
Generation 4
, and
so on. For example:
Year
|
Quarter
|
Month
.
