Dear All,
Today, a data model issue for you. I have the following issue in the fact table of my cube when I extract data from R3:
Shipment Number
-Shipment Cost Document
-Shipment Cost Item---Value
1020--
20
1020--
20
1020--
20
Total----
20
Shipment number is coming from the VTTK table in R3 and there is one shipment header there. There are 3 records for Shipment Cost Document and Shipment Cost Item coming from the VFKN table. The 1 record from VTTK is then multiplied 3 times to give the value 60 - however this is incorrect as the value should only be applied at the document header level.
Currently I am using Exception Aggregation to attain the value 20 - for performance reasons this is not the best solution - I need to solve this by changing the data model.
Top marks for the person who can point me in the right direction,
Ron.
Edited by: Ron Burgundy on Jan 11, 2008 6:37 PM
Edited by: Ron Burgundy on Jan 11, 2008 6:40 PM