Moving Data from one model to another Model

[former_member542409]

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

[former_member186338]

Sorry, but the calculation logic is not clear!

Please read: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

and provide required info, explaining the required logic with sample reports etc...

And yes, your script syntax is incorrect and it's not possible to understand the required logic based on incorrect script.

[former_member542409]

User wants to enter data in the ownership model that will be entered on periodic basis and wants to get the calculated results in the Consolidation model. Please see details below:

For the accounts BSC_1,BSC_2, BSC_3, BSC_4 , input form will be used to save the data there. After that, user wants to see the calculated values in BG_1 , BG_2 , BG_3, BG_4. Account;Model type already shared in the main question. The logic that needs to be created for this req. will be executed on demand basis to push the calculations.

[former_member186338]

Sorry, but looks absolutely strange!

Ownership model IS NOT used for data entry like you mentioned. It's used for ownership calculations.

Then - you can't save data to the member with member formula (by design).

Unable to understand the business logic! Do you understand it?

[former_member186338]

P.S. If you want to enter PERIODIC values - create a new model, don't use Ownership - it's dedicated for Consolidation process!

[former_member542409]

We update the ownership - OWNACCOUNT,METHOD, GROUP using manual loads/input form. So I don't see any issues in saving data to BSC_1, BSC_2, BSC_3, BSC_4 using input. Now these accounts will not be used in the default logic since the account IDs are hard coded of the OWNACCOUNT.

Business is using Ownership model because they don't have any Standard Finance type model and wants only data entry mode. Now, since consolidations model has dimension account that contains OPSCONT(also a member Formula), so they want the final calculated value in the consolidation model only and wants to save the values as well.

[former_member542409]

already suggested them but they don't want to create a new model.

[former_member186338]

You can do whatever you want, but it's a not supported configuration. The resulting issues may happen at any moment.

What is the issue to create extra Finance model???

For the rest - what is the issue?

You have BSC_1, BSC_2, BSC_3, BSC_4 accounts in Finance model

You have same accounts BSC_1, BSC_2, BSC_3, BSC_4 in consolidation model.

You copy using DESTINATION_APP with RENAME_DIM for account

Then member formulas will calculate results in Consolidations.

[former_member542409]

This is exactly what I was doing using Ownership model.

[former_member186338]

Sorry, but next time the customer tell you that he wants: 2*2=5

It's your responsibility to prevent customer from potentially dangerous decisions.

[former_member186338]

Don't use it!