SAP BPC Script logic rule or transformationfile rule for missing movementtypes in data load

[dan77]

Dear BPC Experts,

we have some problems with the data load from BW via Data Manager. We use the SAP BPC10.1 Standard model for the consolidation. We have the following problem when we load data from BW to BPC.

Some of our Profit Center have missing movement types in the Balance Sheet and some of them have the right movement types. When we load data for excample we have for some Profit Center the movementtype 120 at the item 2113340000A and for some Profit Center the movementtype is missing. in this case we would like to write the movementtype 100 for the profit center, where the movementtype is missing.

We need it just for some balance sheet items where the movementtype is missing.

At BPC we already implemented the rule in transformation file for the items, that if there is no movementtype BPC should write it at the movementtype F_CLO. This works fine for alle items and all profit center.

MOVEMENTTYPE=*if (0MOVE_TYPE = *str() then *str(F_CLO);0MOVE_TYPE)

But then we get also the movement F_CLO for the balance sheet items where the movementtype 100 should be there. For the PL and BS items which not need movementtypes the rule works fine but not for the BS items which need other movementtypes then F_CLO.

Because we have calculation rule for the balance sheet items, where the movementtypes from this items will be write f.e. from 120 on F_CLO to get the total balance sheet on F_CLO also. In this case we get the problem, the movementtypes value at this item is 0 (moavementtype f.e. 120) and then BPC write 0 also on the F_CLO where we had value bevore, because the rule is running.

Can you help us with this problem to get for specific items the missing movementtype on 100 for this Profit center where the movementtype is missing and for the other items where we do need movementtype for F_CLO?

I tried it with script logis but it does not work.

Thanks and best regards

Daniel

[former_member186338]

If you have some property (ex BAL_FLAG = X) to check that account is BS then

MOVEMENTTYPE=*if (0MOVE_TYPE+BAL_FLAG= *str(X) then *str(F_120);0MOVE_TYPE = *str() then *str(F_CLO);0MOVE_TYPE)

[dan77]

Do you mean the property at the Item dimension?

Sorry, for better understanding the rule: Would the rule leave the movementtypes for the profit center where the movementtype is there f.e. 120, 140 etc and just fill 120 for the profit center and the BS items where the movementtype is missing or would it now put 120 to all BS items?

[former_member186338]

dan77

Yes, some property to check that item is BS

In my string the logic is:

if item is BS and 0MOVE_TYPE is empty - then 120

Else if 0MOVE_TYPE is empty - then CLO

Else 0MOVE_TYPE