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