Not as easy at it would seem

Version 1

    Subject: RE: Not as easy at it would seem
    Replied by: Luis Yrigoyen on 09-02-2012 03:21:24 PM
    The reporting guide:
    www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/intelligence_suite/intelligence_suite_852/user/guide/CUICUserGuide85x.pdf

    A thread (you can find a few reports in here):
    http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/4257067

    If you have access to webview templates (this is from the thread above):
    the webview reports can be imported straight into CUIC without any modifications (well, so far I haven't ran into any problems).
    Just copy the query from the srd file. The query string is between the "retrieve=" and " arguments="
    Create the report definition and set the Query Type as "Anonymous Block", choose your data source real time or historical.
    Paste the query string and don't change anything.
    Click on Create Parameters (3 parameters will be created)
    Change the @end_date and the @start_date parameters to DATETIME
    Change the other parameter to DECIMAL
    Click Create Fields (the fields will be created)
    Click on the Parameters Tab
    Select the DECIMAL parameter
    Click Edit
    On the Value List drop down choose the corresponding value list (i.e. if you DECIMAL parameter was @agtteam_list then choose the Agent Teams value list)
    Click Update Field
    You can now play with the fields' formats and footers.
    Create the Report and do your groupings (i.e. for an agent reports you would want two groupings 1 = Team Names, 2 = Agent Names.

    these steps have worked for me so far in importing 15 webview reports to CUIC 8.5.2
    This document was generated from CDN thread

    Created by: MICHAEL GUDELL on 09-02-2012 02:39:14 PM
    Ok, I'll admit I was trying to take a shortcut to adding a custom report to CUIC.    It seemed that exporting the report that queries the tables I want and modifying the .xml file to use my select statement and importing the report defination in would yield either in the results I wanted, or errors due to required fields no longer appearing in my select statement. 
     
    Instead, although I know the report is importing since a report with the new name appears in my report folder, it is exactly the same as the report I exported (with a different name of course).  Looking at the SQL for the new report I see exactly the statements that I removed.  Nowhere in the xml file that I imported is the original SQL included, but yet it's there.  I've deleted the report in CUIC and reloaded, same thing.   Obviously I don't understand how these xml definitions are imported and used. 
     
    Can someone point me to some documentation that explains how to build the preverbale "hello world" type of custom report that I can build on?  I'll attempt to RTFM if I only can find it. 
     
    Exporting a canned report yields 6000+ lines of code, which is slightly intimidating. 
     
    Humbly yours,
    MG

    Subject: RE: Not as easy at it would seem
    Replied by: MICHAEL GUDELL on 14-02-2012 04:34:36 PM
    Thanks, I should have mentioned I'm using ver 8.0. The export file that the GUI produces is an .XML file. Within that .xml file is a StatementText tag that contains the SQL. I'm making a change to that SQL and importing the report definition back in to CUIC. No errors occur (unless I don't change the name, then it warns I'm overwriting) Running the report and viewing the SQL shows the old code and not what I added.
     
    UPDATE: after reading earlier posts, I think I am having difficulty doing this because CUIC is under a standard license, and not premium. 
     
    In case I'm missing something else obvious, I'll post the SQL I'm trying to get into CUIC so the customer can put it in a dashboard.

    select  sum(CallsHandledToday) from Call_Type_Real_Time where DateTime between  '02/17/2012' and '02/18/2012'

    Does anyone know of a canned report/view that I can edit to get this result?