Transformation of 0SD_C03

41 Views

Hi Experts,

I am confused about how to create the transformation for Cube 0SD_C03.

What i have done so far:

1. Activated the Datasources in R/3 and dragged some fields required from communication structure.

2. Replicated it in BI system.

3. Migrated the Datasource in BI System.

Now when i try to create the transformation between the datasource 2LIS_13_VDITM (for billing item), many of the fields like document number, item number, customer gropu, material group etc that are available in my Datasource are not there in the cube.

Another thing that its taking data from multiple DataSources like 2LIS_13_VDHADR, 2LIS_13_VDITM, 2LIS_11_VDHADR & 2LIS_11_VDITM.

I need data from all of them how should i perform mapping, not getting it.

Please suggest me how to perform the mapping, its very urgent.

Thanks !