cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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 12015.012015.022015.032015.042015.052015.062015.072015.082015.092015.102015.112015.12
600600505050125125125125125125125
60061010001000100012001200120012001200120012001200
60062020002000200020002000200020002000

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 12015.012015.022015.032015.042015.052015.062015.072015.082015.092015.102015.112015.12
600600500050005000500050005000500050005000500050005000
600610100001000010000100001000010000100001000010000100001000010000
60062015000150001500015000150001500015000150001500015000150001500

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?

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

Hi Saravanan,

Change your logic as following:

*WHEN CSS_ACCOUNT

*IS 600600

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

*ENDWHEN

Best Regards,

Arjen

former_member186338
Active Contributor
0 Kudos

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