Adding Relative dates to CUIC8SummaryTemplates20110311

Version 1

    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!