Blogs

From time to time we hear of customers who want to print scheduled reports. They want their report to be sitting in the printer waiting for them in the morning, that sort of thing. CUIC doesn't support this as built-in functionality, but you can do it using Microsoft Outlook.
...Read More

 

There is quite a bit of interest in different techniques for using multiple AW/HDS servers with a single CUIC instance, for a number of reasons.

One reason people typically want to use multiple AW/HDS servers is to spread the load from a CUIC instance to multiple data sources. I've already blogged in the past about ...Read More

 

With the release of CUIC 7.5.3, there is one grid, the grid that was previously known as the "grouped grid". Since it now supports dynamic sorting it is now the only grid available.

One of the nice things about this grid is that much of its appearance can be customized by modifying the CSS (cascading style sheet) file that dictates its appearance. This is an undocumented technique, but should be fairly straightforward for anyone with a bit of HTML experience.
...Read More

 

I've just published a fairly comprehensive list of ways to improve performance of CUIC 7.5.x on the Developer Community at http://bit.ly/85kB.

There are a few items that I've covered in blog posts before, but a ton of new content as well. The document covers the following topics:

  • Server considerations
  • Configuration options
  • Database maintenance
    • ...Read More

 

Want to show off your Web 2.0 mojo? Here's a fun way to share reports with your Twitter contacts.

First, find the report you want in the Report Manager, right-click it, and click on the Report Info context menu item.



The Report Info dialog is very handy, it gives you all the information you need to access a report without using the CUIC menus. Here, we want the "Interactive Grid Permalink":


...Read More

 

When you write a custom report, it's always a good idea to use the SQL NOLOCK hint to improve performance and reduce the chance of deadlocks.
...Read More

 

In some very specific instances, you may want CUIC Web servers to share a database but query different AW/HDS servers, to split load. At first glance this doesn't seem possible as the AW/HDS that is queried is defined by a data source, which is stored in the CUIC database. However, there is a workaround which I'll show you in this post.
...Read More

 

Most people don't realize just how extensible CUIS is. You can do a lot with it, however, if you know what you're doing.

For example, most people don't realize that you can build a completely custom display using custom-built XSLT files. It's true! You can give CUIS your own stylesheets, and then tell the report to use that stylesheet instead of the default displays.
...Read More

 

Showing 8 results.
Items per Page 20
of 1
First Previous Next Last

Forums

« Back to Contact Center Reporting

CUIC summary reports showing multiple dates per day due to time zone

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
CUIC summary reports showing multiple dates per day due to time zone
Answer
12/14/12 10:15 PM
Hi, I'm running CUIC version 9.0.1.
I downloaded the supplemental summary reports from the CDN site but I'm running into issues.
UCCE and CUIC are in UTC.  CUIC data sources are in UTC.  Users are in Mexico/General (UTC – 6).
Basically, when we run summary reports from a system in UTC and users in UTC – 6, the summary reports split the days showing two dates per day and affecting some of the columns' numbers.
CUIC is designed to adjust to the user's timezone.  When the users run the "detail" reports (the reports showing the day's intervals i.e. 15 min or 30 mins) the data is displayed with the user's local date and time.  The user sees his/her local day displayed from 0:00 hours to 11:59 PM when in reality in the DB the data is 06:00 hours ahead--this works fine. 
It's only when we run "summary" reports (Daily, Weekly, Monthly)  that the date mask gets distorted.
The summary reports are basically the same reports as the "All Fields" reports but with the time zeroed out to be able to group
them i.e. DATEADD(day,DATEDIFF(day,0,DATE FIELD,0).  CUIC doesn't seem to like this.
I've also tested with CONVERT(datetime, CONVERT(varchar(10), Date Field, 112)) but no go.

A colleague was able to fix this issue in a CUIC 8.5 server by converting the date to string so that CUIC will not try to change it but that didn't work.
 
In the Call Type Historical All Fields Daily
chaged this:
Interval=dateadd(day,  datediff(day,0,  CTHH.DateTime)
to this:
Interval=convert(varchar(12),dateadd(day,  datediff(day,0,  CTHH.DateTime), 0),107)
 
thanks
 
Flag

RE: CUIC summary reports showing multiple dates per day due to time zone
Answer
12/27/12 3:14 PM as a reply to Luis Yrigoyen.
I was able to fix this issue by:
1.Making a copy of the interval definition (the all fields stock definition) and renaming it - Dialy or weekly, etc.
2. In the new definition, change the Interval field (DateTime) format to mm/dd/yyyy.
3. Create a new report and point it to the new definition
4. In the grouping section, use the Interval as one of the grouping fields and choose one of the built in summarization filters (Daily, Weekly, Monthly)
5. IN the same grouping section check the "Show Summary Only" check box
 
Flag

Collateral


No files available