2 dimmensions hierarchy

30 Views

BPC MS 7 SP4

Hi Experts,

For a reporting issue, I need to create a hierarchy with two dimensions. Let say Account and Cost Center on this way:

CostCenter_1

Account_1

Account_2

Account_3

CostCenter_2

Account_1

Account_2

Account_3

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:

Account_1 (original)

Account_2 (original)

Account_3 (original)

CC1_Accoun1

CC1_Accoun2

CC1_Accoun3

CC2_Accoun1

CC2_Accoun2

CC2_Accoun3

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.

Iria