Skip to Content
0
Former Member
Jan 11, 2008 at 05:37 PM

Data Model Issue

27 Views

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--


3333
1
--


20

1020--


3333
2
--


20

1020--


3333
3
--


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