Map dimension value to another dimension in BPC

[former_member590808]

Hi,

We are fetching data from an ADSO Z_OVERH. Z_OVERH has data at Cost-center(columns name: Z_CC) and accounts(column name: Z_ACC) Granularity. I am fetching this data into BPC cube where I want the data to be at Entity and accounts granularity. In transformation file am mapping

Cost-center =*NEWCOL(NOCC)

And in Entity dimension I want if Dimension cost center value is 03_SYST then it should be SF048 in entity section. is this possible ?

Please help.

[former_member186338 · Accepted solution]

"I just gave an example for 03_SYST, I have to map 1367 cost centers" - sorry, but you have to properly explain your requirements!

Also easy:

Transformation file:

*MAPPING
Entity=Z_CC

Conversion file for Entity:

External   Internal
03_SYST    SF048
...

Each line will define the mapping of one cost center to one entity

[former_member186338]

Easy!

*MAPPING
Entity=*if(Z_CC=*str(03_SYST) then *str(SF048);???)

no idea about the case when Z_CC <> 03_SYST

If you need list of mappings then you have to use conversion file

[former_member590808]

Thanks for the revert Vadim.

I just gave an example for 03_SYST, I have to map 1367 cost centers and this formula will not be feasible there.Is there a way to map the same thing in conversion file ?