Skip to Content
0
Former Member
Sep 14, 2007 at 01:46 PM

Using counters in Info Cube

44 Views

Hi everyone. Here's my problem. This scenario is simplified. I have an ODS which is at the Delivery Number and Delivery Item level. I am loading this ODS into an Info-cube which is only at delivery number level. I need to count the number of deliveries that go into the cube, not number of line items. For example, if delivery number 12345678 has 2 line items, I only want to count this as one. Can you tell me how to do this? When I put a counter key figure in the cube and move 1 to it, and then do a sum on this counter field, the total number I come up with corresponds to the number of line items, not the total number of delivery headers.

I appreciate everyone's help. Thank you.