Hello experts, I'm using PBCS
I have to copy some data but I can't use datacopy because I have to CONCATENATE members with string.
My assignment is copy:
Account1->Entity1 to Account1_Aux->Entity1_Aux
Account2->Entity2 to Account1_Aux->Entity2_Aux
Account3->Entity3 to Account1_Aux->Entity3_Aux
Account4->Entity4 to Account1_Aux->Entity4_Aux
....
Also I have to copy value of Total dimension Project to Project_NA.
So my desired result should be:
Account1->Entity1->Project to Account1_Aux->Entity1_Aux->Project_NA
Account2->Entity2->Project to Account2_Aux->Entity2_Aux->Project_NA
...
I thought to work with UDA's to achieve this so my account dimension has UDA's in (Account1, Account2, Account3, Account4) called Account_UDA and my Entity Dimension has UDA's in (Entity1,Entity2,Entity3,Entity4) called Entity_UDA
Members (_NEW) are created in my dimensions but they haven't any UDA's.
My code is:
FIX("FY20",@UDA("Entity","Entity_UDA"),@UDA("Account","Account_UDA"),"Project","Project_NA")
"Jan"(
@MEMBER(@CONCATENATE(@NAME(@CURRMBR("Account")),"_Aux"))->@MEMBER(@CONCATENATE(@NAME(@CURRMBR("Entity")),"_Aux"))->"Project_NA"=@MEMBER(@CURRMBR("Account"))->@MEMBER(@CURRMBR("Entity"))->"Project";
)
ENDFIX
My rule is validated and deployed correctly but when I execute this rule I have this error:
Could you help me with this business rule? and it is necessary to force create block? It is necessary to fix Project and Project_NA in FIX?
Thank you very much!!