Dimension Hierarchies - Level-Based Measures - Share Measures - Parent-Level Object - Child-Level Objects - Number of Elements - Level Columns - Level Keys - Preferred Drill Path- Time Dimension- Chronological Keys
Standard
Why do We Create Dimensional Hierarchies?
Dimensional Hierarchies are created to configure drill downs, level based measures and Aggregate Navigation
What are level based measures?
Level Based measures are those measures which are computed at a specific level. These measures displays the values at their specified level even if it is queried with a low level attributes.
Explain the significance of Number of Elements at this level in Dimensional Hierarchy?
"Number of Elements at this level" is used to specify the number of distinct records at a specified level. OBIEE Server uses this in Aggregate Navigation to generate the Optimum SQL.
Standard
Why do We Create Dimensional Hierarchies?
Dimensional Hierarchies are created to configure drill downs, level based measures and Aggregate Navigation
What are level based measures?
Level Based measures are those measures which are computed at a specific level. These measures displays the values at their specified level even if it is queried with a low level attributes.
Explain the significance of Number of Elements at this level in Dimensional Hierarchy?
"Number of Elements at this level" is used to specify the number of distinct records at a specified level. OBIEE Server uses this in Aggregate Navigation to generate the Optimum SQL.
No comments:
Post a Comment