Skip to Content
0
Former Member
Mar 11, 2010 at 07:00 PM

How to load several key figures using only 1 Transformation File

129 Views

Hi everybody,

we are trying to load several key figures (net sales, discount1, discount2...) using only 1 transformation file directly from a BW infocube. We are using SAP BPC 7.0 Version.

However we don't know what to put in the *MAPPING section in order to get the different accounts related with the corresponding Key Figures.

That is:

Key figure 1 Key figure 2 Key figure 3

2010.JAN, SPAIN, PRODUCT1... 1000 500 200

We would like to link Key figure 1 with our Account 1, Key figure 2 with our Account 2 and so on. We would like to avoid developping a transformation file for each key figure in order to optimize the system maintenance.

We have tried using *IF clauses in both the Account and the Amount but we did not succed.

Any idea out there?

Kind regards

Albert Mas