Skip to Content
avatar image
Former Member

Conditions in transformation to load

Hi All,

If company code is C001 then i want to be ID as same i.e 3001 else if company code is C002 than it has to append with CC_3001 to avoid duplicate records as BPC does not allow duplicate ID.Can you please suggest me how i can do this. Thanks!

Cost centre

COMP_CODE

CO_AREA

30001

C001

C001

30001

C002

C002

30002

C001

C001

30002

C002

C002

-Vishu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 18, 2015 at 08:10 AM

    Hello Vishu,

    Try as mention below:

    ID=COMP_CODE+*STR(_)+Costcentre

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 05:31 AM

    Hi Vishnu,

    Do you want to change the ID's of Costcenter dimension?? and all the costcenters starts with 3 as you mentioned in the table??

    Please clear your requirement.

    Regards,

    Meenu

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 05:46 AM

    Hi Vishu,

    Can you try this

    IF(COMP_CODE=C001 THEN COST CENTER;COMP_CODE=C002 THEN *STR(CC_)+COST CENTER)

    Shrikant

    Add comment
    10|10000 characters needed characters exceeded