For a few of our customers we need to report on a large group of agents that are multi skilled. For instance, a monthly report on all agents and on all skills. The result should be one line per agent per skillgroup per day.
Trying different ways, with standard templates this does not work as one easily exceeds the upper limit of 8000 rows. Re-writing the standard queries results in large overhead on the server, as these are not very efficient.
Trying to create new stored procedures also gives problems, as this is not allowed on the AWDB or HDS, and thus a separate database is created. As the report now runs against a non standard data source, there is suddenly a upper limit of only 3000 rows,, like when you run a real time report.
Does anyone out in the field has experience with reporting on large UCCE environments using CUIC?
Thanks in advance,
A suggestion is to create daily reports that still use the standard tables, this will reduce the number of rows and get you
past the 8000 limit.
You just need to modify the underlying sql query to group the data by day.
For further assistance you can contract for a fee based service from the Cisco Advanced Services custom engineering team. To contact them send an email to email@example.com
Thank you for your reply. However, I feel that a reporting package for large contact center environments should standard be able to report on large numbers, customers are not satisfied with a paid solution by either Cisco or the Partner. Surely this question has come up with other large environments?
Have to agree with Jeroen as I am having exactly the same questins being asked by my customers and the fact that you cannot change that limit manually is frustrating
Can be used sql statement in query text or stored proc text:
SET ROWCOUNT X,
where X is enough value
It was helpful for my custom report solution.