1. Administrator's Guide
  2. Application Design Best Practices
  3. Managing Dimension Design
  4. Hierarchy Top Levels
  5. Best Practice Example

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.