Best Practice Example
Using a Product hierarchy as an example:
Single Hierarchy Dimension
Dimension Root Member (Product) Data Storage: Store Data
1st Generation 2 Hierarchy (Total Product) Aggregation Operator: Addition
-
1st Child (All Products) Aggregation Operator: Addition. The rest of the Product hierarchy is placed under this member.
-
2nd Child (NoProduct) Aggregation Operator: Addition. This is the member used if data points don’t have an associated Product member.
Multiple Hierarchy Dimension
Dimension Root Member (Product) Data Storage: Label Only
-
1st Generation 2 Hierarchy (Total Product) Aggregation Operator: Addition.
-
1st Child (All Products) Aggregation Operator: Addition. The rest of the Product hierarchy is placed under this member.
-
2nd Child (NoProduct) Aggregation Operator: Addition. This is the member used if data points don’t have an associated Product member.
-
-
2nd Generation 2 Hierarchy (Alternate Hierarchy) Aggregation Operator: Ignore.
-
3rd Generation 2 Hierarchy (Alternate Hierarchy) Aggregation Operator: Ignore.
-
…Nth Generation 2 Hierarchy (Alternate Hierarchy) Aggregation Operator: Ignore.