semi additive measures

Question

I have a fact table as below:

PID              EKG UniqueNumber ActivityDate  QuantityonHand  ActivityTime

4                  140   623  01-01-2012 0 45678

4                 141   624                01-01-2012        1                          45689

5                 120    323              03-03-2012        1                           56324

5                 120    323              03-03-2012        1                           75423

 In the above, I need to get for each product, get the max quantity on hand at the end of the day. Any suggestions are helpful

Answer 1

Could you please follow the link, hope it will help you.

http://www.sql-server-performance.com/forum/threads/semi-additive-measures.2774/