SAP BPC, Assign values to a dimension in terms of another dimension

[Former Member]

please i need your opinion.

According to the example below the flat file don´t contain the dimension "Intco", when I go to load in BPC I need "INTCO" dimension which depends on the account code

If there is any way to do this process should allow plenty of conversions

Thanks

1.Flat File
Account	Entity
1111125	ABC
1143564	ABC
1116538	ABC

Transformation   & Conversion File
Conversion Table
Account	Intco
1111125	AB
1143564	AC
1116538	AC

2.BPC
Account	Entity	Intco
1111125	ABC	AB
1143564	ABC	AC
1116538	ABC	AC

[Former Member · Accepted solution]

Hi ALEJANDRO,

Try to map INTCO = ACCOUNT ... But before doing that check whether AB,AC are there in the INTCO Master data.....

& Then use the conversion file as

Account	Intco
1111125	AB
1143564	AC
1116538	AC

Aravind

[Former Member · Accepted solution]

Thanks, working for me.

[Shrikant_Jadhav]

Hi Alejandro,

In transformation file map ACCOUNT = INTCO

You can maintain all the conversions (ACCOUNT to INTCO) mapping in conversion file.

Shrikant