Microstrategy Analytics

Recursive Hierarchies in Microstrategy Recursive Hierarchies: Explanation A recursive hierarchy or recursive dimension, usually consists of elements that point to other elements pertaining to the same attribute with a parent-child relationship. A classic example is an organization chart: This information can be stored in a recursive fashion using only one table with two ID columns: Problem Recursive hierarchies are not supported by MicroStrategy Recommendation Explode the schema from recursive to dimensional Workaround / Solution The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy (turning it into a traditional snowflake schema). A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child.