For a report that is being designed in BI, we need to pull one detai in from standard hierarchy. In client's std hierarchy there are seven nodes (levels) & Cost centre appears on the last node i.e. 7th. We need to show FI actuals with cost centres with level 5.
So I tried to find the tables wherein I can see the details like cost centre & all nodes (at least upto level 4...going backward from level/node 7 where CC lies) but so far no success.
Can you enlighten me about this ?
thanks in anticipation,