Dimension management
For each dimension (except period, scenario and account) Tagetik provides the user with the following utilities:
- All. It behaves like the reading from fixed point. It allows to read data summing up on all the elements belonging to the dimension.
For example, if data on the database are:
| Entity | Account | Scenario | Category | Dest1 | Dest2 | Period | Amount |
|---|---|---|---|---|---|---|---|
| A00 | C00000 | 2013BDG | $AMOUNT | D11 | D21 | 01 | 50 |
| A00 | C00000 | 2013BDG | $AMOUNT | D11 | D22 | 01 | 30 |
| A00 | C00000 | 2013BDG | $AMOUNT | D11 | D23 | 01 | 20 |
and we write ...:=[C00000](Dest2.All) then read data are:
| Entity | Account | Scenario | Category | Dest1 | Period | Amount |
|---|---|---|---|---|---|---|
| A00 | C00000 | 2013BDG | $AMOUNT | D11 | 01 | 100 |
- Ancestor. Allows to read data summing up on alla the elements related to the parent node of N level
- Parent. Allows to read data summing up on all the elements related to the parent node
- RefLeaf(Parent([hierarchy_code])). Allows to read the reference element from a given hierarchy.
For example if we write … := [C00000](Entity.RefLeaf(Parent([01]))); the system read, for each entity, data from the reference element of the parent node of the 01 hierarchy's entity
- RefLeaf(Ancestor([hierarchy_code],level)). If we write … := [C00000](Entity.RefLeaf(Ancestor([01],2))); the system reads, for each entity, data from the reference element of the second level parent node of the 01 hierarchy's entity.