BPC 10.0 Transformation mapping- IF Condition

[Former Member]

Hi Guys

Our objective is to add a dynamic CCtr member when certain conditions are met when loading data from a BW infoprovider to BPC cube using a BPC transformation file.

The error message is ‘Line1 :Command failed ; end position is out of record index’

We are following the EPM End User Guide Example for a multiple conditional test as follows:

*If (Condition1 then Action1;Condition2 then Action2;Default Action)

We have tried the following BPC Transformation syntax for CostCenter:

OPTION – 1 (pls see image attached)

COSTCENTRE=*If (0COSTCENTER+0WBS_ELEMT(1:2) = *Str(CS) then *Str(6)+ZCSCH_COD+*Str(201);0COSTCENTER = *Str() then *Str(CC000);0COSTCENTER(3:10))

OPTION - 2(pls see image attached)

COSTCENTRE=*If (0COSTCENTER(3:3)= *Str(6) then 0COSTCENTER(3:10);0COSTCENTER +0WBS_ELEMT(1:2) = *Str(CS) then *Str(6)+ZCSCH_COD+*Str(201);*Str(CC000))

Results: With both options, Condition 1 results in the correct ‘accept count’, with the relevant transactions being successfully modified. However, transactions that fall within condition 2 OR the Default Action, land in the ‘Reject Count’

Any insights much appreciated; we wish to avoid using a badi if possible.

Thanks Glen

Product Details:

EPM 10.0 SP20 Patch 1 .NET4 Build 9042

CPMBPC Release 810: SP Level 0004 SAPK-81004INCPMBPC

[JohnL]

Hi Glen, is this a duplicate of:

https://answers.sap.com/questions/34135/bpc-100-transformation-nested-if-statement.html

[Former Member]

Hi John - Yes. Are you able to remove this one plz?

Thanks

Glen