Adding Relative dates to CUIC8SummaryTemplates20110311

Document created by cdnadmin on Jan 25, 2014
Version 1Show Document
  • View in full screen mode

Subject: Relative dates are supported for anon block & stored proc in CUIC 9.0
Replied by: Carmen Logue on 27-08-2012 03:38:28 PM
Hi -- Also wanted to point out that we added relative date support for anonymous block and stored procedure reports beginning with CUIC 9.0.  Note that  CUIC 9.0 is compatible with Contact Center Enterprise 8.x and 9.0.
 
--Carmen
This document was generated from CDN thread

Created by: James Belitz on 27-08-2012 03:37:13 PM
I am trying to add a filter criteria for relative dates on the downloadable CUIC8SummaryTemplates20110311.zip. I have successfully created a SQL query that pull the data that I deem interesting, but when I import this query into CUIC I receive the following error 'Error [10601] The formatting of the grid was not successful"
 
I believe my problem occurs after the copy of the sql query into an anonymous block, create parameters and then create fields. I have a field defined as @RelativeDate and it is not importing as a decimal (interger), rather it imports with next "Select" statement in the data clause for this field.
 
I have attached the sample report. You will need to have CUIC Value List for Relative dates with a value list query:
SELECT 1 AS , 'Today' AS  UNION
SELECT 2 AS , 'Yesterday' AS  UNION
SELECT 3 AS , 'This Week' AS  UNION
SELECT 4 AS , 'Last Week' AS  UNION
SELECT 5 AS , 'This Month' AS  UNION
SELECT 6 AS , 'Last Month' AS  UNION
SELECT 7 AS , 'Year-to-Date' AS  UNION
SELECT 8 AS , 'Last Year' AS 
ORDER BY ID
Any help with troubleshooting this "grid formatting" error is much appreciated!

Subject: RE: Adding Relative dates to CUIC8SummaryTemplates20110311
Replied by: James Belitz on 25-09-2012 09:19:10 AM
With the help of TAC, a solution has been found. From the attached sql query change the following local variable definitions from
SELECT @AbsBegin = :start,
 @AbsEnd = :end,
 @RelativeDate =:RelativeDate

to

SET @AbsBegin = :start;
SET @AbsEnd = :end;
SET @RelativeDate =:RelativeDate;
 

Subject: RE: Relative dates are supported for anon block & stored proc in CUIC 9.0
Replied by: Troy Dawson on 23-01-2013 02:20:18 PM
Carmen Logue:
Hi -- Also wanted to point out that we added relative date support for anonymous block and stored procedure reports beginning with CUIC 9.0.  Note that  CUIC 9.0 is compatible with Contact Center Enterprise 8.x and 9.0.
 
--Carmen

Carmen, do the Relative Dates for Anon blocks in CUIC 9.0 match the same layout and functionality as the Relative Dates for DB Queries in CUIC 8.5? (do they look and operate the same?) Does it also include Absolute Date Range and Specified Time Period?
Thanks!

Attachments

    Outcomes