I am building an OLAP table for cases. Cases have multiple users over time. I added a Max Activity time KPI. and want to list the corresponding User and Activity. I only need one Max Activity time per case, not all activity times.

Hi Michael ,

Not Sure if I understood your question correctly and answered here.

My Undestanding:

You want to show the user and activity & eventtime which has max(activity event time per case)

Here is my response.

Better do the same using a trsansformation.

• Create a table with following columns

-- Casekey

-- User

-- activity Name

-- Max(event time of the activity)

In the where clause of the select use eventtime=(max eeventtime) [ User co-related SubQuery] to form the select or the data and use the same select to create the table..

Then in the datapool - link the casekey of the new table to the casekey of the case table.

Regards

Ayan

Hi Ayan,

Thank you for your reply.

However, I am trying to see if there is a way in PQL to handle this.

I would prefer an option to avoid making another table for the data pool as that would use more resources. This data would not be used as often as other tables.

I am able to get the DOMAIN_TABLE function to work, but with limited success on figuring out if there is another way to pull the data outside of PU functions.

Any other suggestions?

Thank you.