Skip to Content
0

BPC 10.0 Transformation mapping- IF Condition

Nov 01, 2016 at 08:08 PM

104

avatar image
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

option-1-image.png (125.5 kB)
option-2-image.png (120.4 kB)
10 |10000 characters needed characters left characters exceeded
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Nov 07, 2016 at 05:40 AM
0

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

Thanks

Glen

Share
10 |10000 characters needed characters left characters exceeded