Generations and levels are layers in a hierarchical tree structure that defines database member relationships. Generations are ordered incrementally from the top member of the dimension (generation 1) down to the child members. Levels are ordered from the bottom dimension member (level 0) up to the parent members.
|
Note: |
In a dimension that allows duplicate member names, use the unique generation name to identify a layer in the hierarchical tree structure. |
You can create your own names for generations and levels in an outline. The name is a word or phrase that describes the generation or level. For example, you might create a generation name called Cities for all cities in the outline. You can define only one name for each generation or level. Once defined, you can view generation and level names in the Property grid for the selected dimension,
Use generation and level names in calculation scripts and report scripts wherever you need to specify either a list of member names or a list of generation or level numbers. For example, you can limit a calculation in a calculation script to the members of a specific generation.
You can create, modify, or delete named generations in Essbase (ASO) and (BSO) applications.
To create, modify, or delete named generations:
-
In the Dimension Library, right-click a dimension or the application name and select Named Generations.
The Named Generations dialog box is displayed.
-
Click
to add a named generation. Then, double-click the cell under Generation Name and enter a descriptive name.For example, to later publish sales data generated in all North American regions, create a generation called Region.
-
In the Number column, double-click the cell to modify the number automatically provided.
Note:
You cannot change numbers that are associated with DTS members.
-
Perform any of these optional tasks:
-
Click
to remove changes and revert to saved data. -
Click
, to remove a selected generation. -
Click
to save changes and continue to add named generations.
-