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.