In the article (Addressing levels in hierarchies 1), I explained a few basic facts about addressing levels in a predefined hierarchy in TARGIT.
In this article I will take it a bit further – here’s the definition of a table with multiple attributes on the horizontal axis, none of them being a hierarchy – but together they make a custom hierarchy:
In terms of levels things are different now compared to a “real” hierarchy
- Year – level 1 (now expressed(l(1,0))
- Quarter – level 1 (now expressed(l(1,1))
(but you don’t have to use any level parameters if you mean “the lowest level” – that’s default anyway)
The resulting table will look something like this:
So let’s make the same calculation as in the previous article (Addressing levels in hierarchies 1) and make a Year Growth calculation.
However the formula we used before (Sum(d2(l1),0,m1)-sum(d1(l1),0,m1)) will NOT work now. That’s because it’s a custom hierarchy.
The syntax will now be this: sum(d2(l(1,0)), 0, m1) - sum(d1(l(1,0)), 0, m1).
So what you can learn from this article and the previous one is that there’s a big difference between levels in predefined hierarchies and custom hierarchies.
More to come on addressing levels...