Skip to Content

Transformation/Conversion File - Conditional logic

Hello Friends,

Env- BPC10.1 BW7.4

I have requirement to update the Audit trail based on a property of accounts for a special case.

Account dimension in BW and BPC has a property called "InterCompany". If the account has this property flagged as Y, then the Audit trail needs to be updated to Intercompany, else it would the same as passed through BW.

Is it feasible to check the property of a BW infoobject in the transformation or conversion file to get required audit trail. BW raw data cannot be updated now, as it feeds multiple models.

I am looking for a non-abap way, as we are pressing on time.

eg

audittrail = *IF(glaccount_intercompany= Y then *STR(Intercompany); BWaudittrail)

One other way would be to hard code the accounts in the conversion file, and look for a method to connect the audittrail with accounts. But this would be a static list.

Thanks for your time

Ed.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 12 at 03:23 PM

    "I could make Intercompany property Navigational attribute in BW." - after you do it you can use it in the mapping section of transformation file using IF.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 at 08:48 PM

    What do you have in selection when you upload data? Show sceenshot!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12 at 02:31 AM

    Thanks Vadim for your reply.

    We select only based on Leading Ledger, and acttype = INC, EXP .

    We do not want to exclude any data from loading to the model. We need a reassignment of audit trail ID based on one condition.

    I have attached the screenshot.

    delta.png

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19 at 02:19 PM

    These are the steps for using BW properties in BPC transformation files.

    The property needs to be set as NAV in the BW infoobject ( there is a button, to flip from DIS to NAV)

    Change the navigational attributes for this property in BW infoprovider (Right Click on the info provider->Change->Navigational Attributes-> check the box.

    After these steps are complete, you should be able to access this property as a selection in the DM packages.( This is a test to see if the above mentioned steps are complete and accurate)

    After that you can use it in transformation file

    example of the transformation

    AUDITTRAIL = *if(0GL_ACCOUNT__intercompany=*str(Y) then *str(Intercompany); BWAudittrail)

    Note that you have double underscore when dealing with Navigational properties ( __ )

    Thanks

    Ed.

    Add comment
    10|10000 characters needed characters exceeded