Rpe

• Mar 26th, 2007

 

Ok, let's start with the definitions...

hierarchy

A description of the order of levels in a dimension.

In Framework Manager, you define hierarchies in the query subject.

level

A group of query items that must contain a key query item, so that each member within the group is unique. Levels may contain other non-key query items. Levels are parts of dimensions.

For example, a geographical dimension might contain levels for region, country, State.

Region : Americas
Country : US
State:      NJ
 The last level of this hierachy should be unique, because NJ cannot be inside another country than US... basically is to define the level of drill down that you can achieve in your reports and to define the scope of your dimension inside a model.

ASHOK1324

 Profile Answers by ASHOK1324 

• Apr 23rd, 2009

 

Hierarchy defines the order of query items for report to report interactions [RRI]. Hierarchies are defined in query subject to support drill-down and drill-up functionalities.