Skip to Content
0
Former Member
May 14, 2008 at 02:16 PM

How to count purchase requisition positions

209 Views

Hi experts!

I need some advice about how to count occurrences in this scenario:

- The data flow is 2LIS_02_ITM (purchasing documents at position level) -> ODS -> Cube

- A position of a purchase requisition may result in N positions of one or more purchase orders. So relation between positions is: 1 Purchase Requisition Position --> 0,N Purchase Order Position

- We need to count how many purchase requisition positions exists, but the ODS is at purchase order positions level, so when the cube is loaded(the cube doesn't contains neither purchase requisition ID nor purchase requisition position ID) the counter in ODS is grouped generating wrong values.

I don't like modeling the cube at document level in order to get purchase requisition and purchase requisition. That way allows us to count but I refuse to do so.

I hope to be clear enough...

Thanks!!!