BPC 10.0 NW complex mapping when loading data from flat file

[Former Member]

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

[former_member186338 · Accepted solution]

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

[Former Member · Accepted solution]

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

[former_member5472]

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

[former_member186338]

The question author is talking about loading from flat file. How BW is related???