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

CallDetailReport not working

Combination View Flat View Tree View
Threads [ Previous | Next ]
CallDetailReport not working
calldetailreport.xml
Answer
11/7/11 8:38 PM
i just imported the CallDetailReport.xml (from the CDN) to my CUIC 8.0.4. When i try to run the report, i could not see any collections for that report.

I was under the impression while importing the collection would be created automatically? what am i missing?

TIA
Senthil Natarajan
Flag

RE: CallDetailReport not working
Answer
11/7/11 8:49 PM as a reply to Senthil Kumar Natarajan.
what report is that?
where did you download it from?

thanks
Flag

RE: CallDetailReport not working
Answer
11/7/11 9:09 PM as a reply to Luis Yrigoyen.
from Cisco developer network. Listed under documentation.

-senthil
Flag

RE: CallDetailReport not working
Answer
11/8/11 12:07 PM as a reply to Senthil Kumar Natarajan.
from Cisco developer network. Listed under documentation.

-senthil

Hi Senthil,
 
Collections are not imported, when you import a report. Only value lists are imported.
 
Collections are not imported because, collection values are specific to a system. These values will not be applicable for a different system where you might be importing.
 
Thanks,
Datta
 
Flag

RE: CallDetailReport not working
Answer
11/8/11 3:00 PM as a reply to Dattatraya Rooyikar.


from Cisco developer network. Listed under documentation.

-senthil


Hi Senthil,
 
Collections are not imported, when you import a report. Only value lists are imported.
 
Collections are not imported because, collection values are specific to a system. These values will not be applicable for a different system where you might be importing.
 
Thanks,
Datta
 


Is there a document on what/how collections are created for this custom report?
Flag

RE: CallDetailReport not working
Answer
11/8/11 3:09 PM as a reply to Senthil Kumar Natarajan.
If you want to create collections for a given report, you should know which value list it is using. From Value list manager, you can create collections.

To know which value list, edit the report check the report definition name. Go to report definition editor and edit the report definition field which is key criteria field.

Please refer user guide.
Flag

RE: CallDetailReport not working
Answer
11/8/11 4:02 PM as a reply to Dattatraya Rooyikar.
Value list query is "SELECT DISTINCT ANI AS ID, ANI AS VALUE FROM Termination_Call_Detail"

i was able to successfull run this query and see records in the SQL and CUIC successfully validates this query.

Collection query is "SELECT AS ID, AS VALUE FROM WHERE CollectionIdentifierField =<COLLECTIONIDENTIFIER>"

------------

Under Value list i see the CUSTOM value ANI. When i select that ANI and press VALUES button, i see it returns 0 values.

If i aunderstanding you correctly, i need to fix this VALUE even before i start tweaking with collections? right?

-------------

Why am i seeing 0 values, is there any restrictions on the TCD table?

-senthil
Flag

RE: CallDetailReport not working
Answer
11/8/11 4:12 PM as a reply to Senthil Kumar Natarajan.
There are multiple ways of creating collections for a value list.

1. Either using collection query and collection identifier. For this, you need to adjust the collection query rightly in value list. Which I see is not done in your case.
2. Selecting directly required values from Value list values.
3. By wild cards. Collection will pickup matching values from value list.

You can see these options in collection editor.

I see ANI could be a collection which created before. Please edit this collection and check what condition it is trying to match.

Refer user guide for clear instructions.

Thanks,
Datta
Flag

RE: CallDetailReport not working
Answer
11/8/11 7:56 PM as a reply to Dattatraya Rooyikar.
There are multiple ways of creating collections for a value list.

1. Either using collection query and collection identifier. For this, you need to adjust the collection query rightly in value list. Which I see is not done in your case.
2. Selecting directly required values from Value list values.
3. By wild cards. Collection will pickup matching values from value list.

You can see these options in collection editor.

I see ANI could be a collection which created before. Please edit this collection and check what condition it is trying to match.

Refer user guide for clear instructions.

Thanks,
Datta


----
 
Report ran fine after i upgraded the CUIC from 8.0.4 to 8.5.2 (to eliminate a scrolling bug).
 
I can see the value list now populate. Must be a bug in 8.0.4 which prevented the value not being populated.
 
Still thanks for your feedback Datta.
 
Flag

Collateral


No files available