Dear Experts,
Client has a requirement of creating a member(ABC) in the ownership model where the data will be entered using input template Now after that, they want that data to be moved to another model Consolidation where a new member will be created(XYZ) that will have the formula, XYZ = ABC * INCOMESTATEMENT(BASE MEMBER ID). Now I understand I need destination app in order to move the data but I think it can only be done based on properties not by member. I tried to create the logic however it was invalid.


*XDIM_MEMBERSET CATEGORY = ACTUAL *XDIM_MEMBERSET ENTITY = %ENTITY_SET% *XDIM_MEMBERSET TIME = %TIME_SET% *XDIM_MEMBERSET CONSOLGROUP = <ALL> *XDIM_MEMBERSET INTERCO = <ALL> *XDIM_MEMBERSET OWNACCOUNT = <ALL> *DESTINATION_APP = Consolidations
*ADD_DIM COSTCENTERAREA = CC.NA, FLOW = F_ACT, CURRENCY = FC, DATASRC = MD
*RENAME_DIM OWNACCOUNT=BPCGACCOUNT *WHEN OWNACCOUNT *IS ABC *REC(FACTOR=%VALUEUE%,[BPCGACCOUNT].[XYZ]=[BPCGACCOUNT].[INCOMESTATEMENT]*[OWNACCOUNT].[ABC]) *ENDWHEN *ENDWHEN