Skip to Content
0
Former Member
Dec 26, 2006 at 02:34 AM

Modeling last 5 activities

19 Views

I have a CRM Activities cube. Here i get all the activities (Current and Historical) done by the customer on a daily basis. The requirement is to show the Last 5 activities by the customer in the query result everytime i run the query. The last 5 activities is not date dependent. How can i model this....all possible suggestions will be rewarded....

Thank You