Available Data in target model to add while new data is copied from source to target model

[Former Member]

Dear Experts

Planned depreciation amount calculation is available in the model CSS_CAPEX, GL account and time wise for the cost center 1010, LC as reporting currency, version 101 & measure is periodic.

1. Data availability in Source model - All these values are based on assets that are planned for procurement in 2015 for specific time period

Header 1	2015.01	2015.02	2015.03	2015.04	2015.05	2015.06	2015.07	2015.08	2015.09	2015.10	2015.11	2015.12
600600			50	50	50	125	125	125	125	125	125	125
600610		1000	1000	1000	1200	1200	1200	1200	1200	1200	1200	1200
600620					2000	2000	2000	2000	2000	2000	2000	2000

2. Destination_app script logic

*XDIM_MEMBERSET CSS_VERSION=101

*XDIM_MEMBERSET CSS_CC=CC_1010

*XDIM_MEMBERSET CSS_TIME=BAS(2015.TOTAL)

*XDIM_MEMBERSET CSS_ACCOUNT=%CSS_ACCOUNT_SET%

*DESTINATION_APP =CSS_PL

*SKIP_DIM=CSS_AST

*WHEN CSS_ACCOUNT

*IS 600600

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

3. Already Planned depreciation values for the existing assets are available in CSS_PL model as below

Header 1	2015.01	2015.02	2015.03	2015.04	2015.05	2015.06	2015.07	2015.08	2015.09	2015.10	2015.11	2015.12
600600	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000
600610	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000
600620	15000	15000	15000	15000	15000	15000	15000	15000	15000	15000	15000	1500

4. Result - When i execute the destination_app it overwrites the available data in CSS_PL which BPC is suppose to do so.

5. Requirement - How to ensure while copying data from one model to another model, the existing data (As shown in Point No.3) is added to the values (as shown in Point No.1) for the represented time periods.

*I have checked the SCN and have gone through suggestions of BADI but not able to identify a solution for the same. Could this be achieved with script logic?

[former_member186338 · Accepted solution]

Hi Saravanan,

First - what do you mean by "Already Planned depreciation" - explain in details!!! In general you can use different auditid's to store already planned and new somehow...

Second, if you calculate within one script two destination_app copy with the same target - try to combine...

Third, in the worst case use %VALUE%+LOOKUP(...)

Vadim

[Former Member]

Hi Saravanan

This is design issue.

Add audit dimension with hierarchy to the receiving model (as data will be received from different models ) and use specific member for each model.

This way you can differentiate data from all sources and can report at highest level if need total.

Regards

Vinod

[Former Member]

Hi Saravanan,

Change your logic as following:

*WHEN CSS_ACCOUNT

*IS 600600

*REC(EXPRESSION=([CSS_ACCOUNT].[600600]+%VALUE%))

*ENDWHEN

Best Regards,

Arjen

[former_member186338]

Absolutely incorrect, [CSS_ACCOUNT].[600600] is located in the different model!