1. Dimension → Account → Hierarchies → simply drag & drop to configure its structure. (Mandatory, account structure is crucial to verify numbers with your ERP system.)
  2. Dimension → Account → Hierarchies → Verify BalanceSheet structure and IncomeStatement structure
  3. Other GL segments (highlighted in red box above) → Hierarchies → simply drag & drop to configure their structures (Optional)
  4. Please CheckOut first. After editing, remember to Save & CheckIn.


All dimensions have a RNodeType property visible in the Members tab. This column tells you whether it's a parent or a leaf level from hierarchy perspective.
There are 4 types:

  • P - Parent - does not contain data, can only be used as a parent in the hierarchy. Shows the sum of its children.
  • PC - Parent Calculated - does not contain data, can only be used as a parent in the hierarchy. It's calculated by MDX.
  • L - Leaf - contains data, can only be used as a leaf member in the hierarchy.
  • LC - Leaf Calculated - does not contain data, it's calculated by MDX. It can only be used as a leaf member in the hierarchy.

When members are loaded by the ETL process they get RNodeType values corresponding to their position in the default hierarchy. Potential parents without children are not loaded into the hierarchy.

Manually changes of the RNodeType values or changes of the positions in the default hierarchy will not be overwritten by the ETL process.

When you try to set leaf as parent or parent as leaf and save in the modeler, you will get errors.
Then you have two different possibilities:

  1. Move all members with RNodeType L or LC to a leaf position in the hierarchy and move all members with RNodeType set to P or PC to a parent position in the hierarchy. This is normally the recommended action.
  2. It is also possible to change the value of RNodeType so it matches the position in the hierarchy. If you do this, be careful. For example if you change a leaf member from L to P, data stored on that member will not be visible.


  • efp/tech/installguide/basicconfig3.txt
  • Last modified: 2015/11/28 10:22
  • by pcjawo