BPC MS 7 SP4
For a reporting issue, I need to create a hierarchy with two dimensions. Let say Account and Cost Center on this way:
Also it is needed to keep the 2 dimensions, but having the possibility expand this two as one.
What I tried was, create a new account hierarchy on the Account Dimension and fill it with a logic script, as follow:
The problem, besides the maintenance, is it doesnu2019t modify the original combinations between accounts and cost centers (which are the ones using on the process). I tried to create logic to modify the original ones, but It doesnu2019t work properly due the other logics we use.
Anyone knows a way to create a hierarchy using 2 dimensions? Any idea will be of help.
Thank you very much.