Modeling last 5 activities

[Former Member]

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

[Former Member · Accepted solution]

Sendmeinfo,

you can evaluate the activities based on some criteria. If not date there should be some other thing on which we can classify the activities. Based on that you can use conditions to dispaly last five. Please give more details so that we can analyse the case.

[Former Member · Accepted solution]

All activities have a date associated with it. So u are saying that u can show the last 5 by creating a condition based on the activity date????

[Former Member · Accepted solution]

Sendneinfo,

Exactly, you can create a condition for last five activities. Check the parameters while definfg the condition. I means last five activities for a dependent char.

[Former Member · Accepted solution]

Thanks a lot...full points....

[Former Member · Accepted solution]

sendmeinfo,

U can't show your last 5 activities as it.

If you create a condition based on activity date, and if you have more than 5 activities per day, this solution shows the 5 first crm guid of the day !

I have the same problem !

do you have tested that ? what's the issue ?

thanks !

All activities have a date associated with it. So u are saying that u can show the last 5 by creating a condition based on the activity date????

[Former Member · Accepted solution]

I havent tested it, but the condition wwill work on the activity date. Will let you know when i actually test it