Hi all,
Has anyone built an account dimension hierachy using Framework manager? I am trying to build a hierarchy that map the income Statement hierarchy to the lowest GL level.
The problem I have is I have 5 different companies with 5 different income stat hierarchy. I wonder how the account dimension will look like in this case if the user need to drill up and down to each income Stat without the need to see the entire hierarchy for all companies.
To illustrate:
Company1-->Expense-->Salaries,rent,travel
company2-->Expense>Salaries-Managr, salaries-staff,rent, travel domestic, travel oversees
As u can see, company 2 has different hierarchy under expense level
Thanks in advance