To a TM1 developer, alternate hierarchies are sometimes synonymous with ragged hierarchies. When designing cubes for Cognos BI, it’s important to remember that they are structurally different concepts. How you model them in TM1 will affect your Cognos BI reports. Continuing where we left off last month, we will discuss some best practices for handling these hierarchy structures in a Cognos BI context.

Note: As of TM1 10.2, alternate hierarchies cannot be defined separately in the }HierarchyProperties cube. Read more