Skip to Content
0
Jun 19, 2020 at 01:26 AM

Transformation File - Map the target with the property value from another dimension

248 Views

Hi Experts,

I have a question regarding the transformation, hoping you can kindly advise:

In BPC(target) we have 16 dimensions, and in BW(source) we have only 13. The extra three dimensions need to be assigned with the value from BPC ENTITY dimension(three properties) when loading data from BW.

Is it possible to maintain the transformation file - MAP section like below to implement the requirement?

DIM_A = *NEWCOL(ENTITY.PROPERTY1)

DIM_B = *NEWCOL(ENTITY.PROPERTY2)

DIM_C = *NEWCOL(ENTITY.PROPERTY3)

If not (I feel like this is not going to work), is there any other way to do it? (e.g. DIM_A/B/C = *NEWCOL(NONE), in the DEFAULT logic, we REC the records on ENTITY.PROPERTY1/2/3 ?)

(BPC version is 11.0, BW4HANA SP10)

Thanks in advance!