How to Create Ragged/Unbalanced Hierarchy in TM1 Architect
Posted: Fri Sep 15, 2017 4:11 am
I've seen some resources on how to do this in Performance Modeler, but need to know how to do this in TM1 Architect using an ODBC database source (e.g. not using manual editing or cut/copy and pates). Can someone direct me to how to do this?
Simple database source example. Either using Parent-Child hierarchy or Levels hierarchy table setups (either way).
Simple database source example. Either using Parent-Child hierarchy or Levels hierarchy table setups (either way).
ID | Name | ParentID | TreeType | Level1 | Level2 | Level3 | Level4 |
1 | Revenues | 8 | C | Total P&L | Gross Profit | Revenues | Null |
2 | COGS | 8 | C | Total P&L | Gross Profit | COGS | Null |
3 | Labor | 10 | C | Total P&L | Total Expenses | Total Labor & Benfits | Labor |
4 | Benefits | 10 | C | Total P&L | Total Expenses | Total Labor & Benfits | Benefits |
5 | Expenses | 9 | C | Total P&L | Total Expenses | Expenses | Null |
6 | Other | 7 | C | Total P&L | Other | Null | Null |
7 | Total P&L | Null | P | Null | Null | Null | Null |
8 | Gross Profit | 7 | P | Null | Null | Null | Null |
9 | Total Expenses | 7 | P | Null | Null | Null | Null |
10 | Total Labor & Benfits | 9 | P | Null | Null | Null | Null |