Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: zack31 on February 24, 2010, 03:38:20 AM

Title: Hyperion Data Duplication
Post by: zack31 on February 24, 2010, 03:38:20 AM

Afternoon all - have a rather quirky one here. I seem to be getting duplicate results for several users and I can't see why. When I access the agent activity query results the data appears fine (login time 7.9 hours) but when the query results are moved in the report section, the user's login time doubles to 15.98. Has anyone ever comes across this before? It's probably something really easy to fix but it has me stumped! Cheers!

Title: Re: Hyperion Data Duplication
Post by: mark on February 25, 2010, 12:24:32 PM

You could try the following:

In the query section, select the 'Query' menu, sleect 'Query Option' from the drop down.
In the box that opens, tick 'return unique rows'.
Process it and see if that makes any difference.

Title: Re: Hyperion Data Duplication
Post by: zack31 on February 25, 2010, 10:11:44 PM

KEWL! That worked a treat! Thanks heaps mate!