Skip to Content
0
Jun 05, 2018 at 09:53 AM

Moving Data from one model to another Model

218 Views

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

Attachments

consolidation.png (18.5 kB)
ownership.png (12.6 kB)