Skip to Content

BPC 10.0 NW complex mapping when loading data from flat file

Dear Experts,

We need to load data from flat file creating conversion files for Account, Entity and CC (Cost Group); in source system the dimension is called Cost Center and in destination system the dimension is called Functional Area.

In CC/FA mapping we mostly have one to one mapping (CC1 to FA1) but there are some exceptions which are based on specific Entity member.

Example:

CC1 goes to FA1

but for Entity X with CC1 mapping should be

CC1 to FA5

How do I take care of these special cases?

Thanks in advance for the help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 12 at 03:18 PM

    It's possible to have conditional mapping when loading from flat file (IF in transformation file). But you need to provide a detailed sample!

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vladim,

      Example:

      source Account "KP1" is mapped to destination account "Acc1" when source Cost center is "NO_CC"

      source Account "KP1" is mapped to "Acc2" for any other Cost center

      Thanks

  • Jan 12 at 02:44 PM

    Hi,

    Is it possible to do all these logic in BW layer instead of BPC ? In that case your transformation/Conversion logic will be simple 1:1

    Prat

    Add comment
    10|10000 characters needed characters exceeded