Skip to Content
0
Oct 24, 2010 at 02:40 PM

one cube, three data sources - Purchasing

10 Views

I have purchase Group Cube 0PUR_C04

I have three data sources, 2LIS_02_HDR

2LIS_02_ITM

2LIS_02_SCL

I have created transformation between all three datasources to the cube. and scheduled DTPs.

This is fine, but will not cube have redundant data.

I have executed 1st DTP for 2LIS_02_HDR

I have executed 2nd DTP for 2LIS_02_ITM

I have executed 3rd DTP for 2LIS_02_SCL

There are 3 request IDs.

Since I mapped EBELN three times, EBELN is repeating. What process should i follow to load the cube properly?

This is the same with 0PUR_C01 having two datasources 2LIS_02_ITM

2LIS_02_SCL