Hi,
I heard somewhere that cisco had made the WebView templates available for CUIC...does anybody know how to get them?
We're going from 7.5 to 8.5 and I wanted to provide them to my supervisors.
 
thanks

Thanks but I already know about those. I was trying to find them already modified for CUIC.
 
attached are some of the ones I modified in case somebody needs them:

Attachments:

Hi Luis,

Do you have report definitions for these reports..

Thanks
Ram

I agree, but the biggest problem is if I use anonymous blocks we don't get the option of choosing relative dates.

I want the reps where I can get the option of selecting relative dates




From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
Sent: Tuesday, August 30, 2011 07:29 PM
To: cdicuser@developer.cisco.com <cdicuser@developer.cisco.com>
Subject: New Message from Luis Yrigoyen in Contact Center Reporting (CCR) - Contact Center Reporting: RE: WebView Templates for CUIC

Luis Yrigoyen has created a new message in the forum "Contact Center Reporting":

--------------------------------------------------------------
they are included in the zip file; the files that start with DEF are the definitions.

also, the webview reports can be imported straight into CUIC without any modifications (weel, 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

CUIC doesn't have any Outbound Option reports so you can import the webview reports straight in.
--
To respond to this post, please click the following link:

<http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/4429969>

or simply reply to this email.

unfortunately no; you need the Premium license to access the Report Definition designer.
But I believe you can import reports (custom reports) with the standard license. I'm not 100% but I think that when a report gets exported its definition and value lists get also included in the export, so once you imported the required definition and value list will be created.
Any particular report that you're looking for? Would you like me to send you the Webview reports I converted?

Hi Luis,

Furthermore please send me all reports of webview which you have converted for CUIC. Many thanks!!

Regards,
Hammad.

Many thanks Luis!!

Managed to find teh answer in a previous post

The templates are for 8.0.4 and up. Im running 8.0.1.

The templates call for enabling permalinks which are not supported in 8.0.1.

To import the templates just delete the following xml entry from the templates:

<enablePermalink>true</enablePermalink>

Hi,

Very useful discussion, thank you very much. I've standard license and I have imported all summary reports and are working fine, however I've observed that the totals per agent are always missing and this is something essential for the users at my company. For instance when running agent22 in WEbview, you will get the totals for each Skillgroup of each agent and at the very last row of each agent the total for all the calls handled for that agent. For every report in CUIC, either standard or the customs that have been uploaded like the summary ones, there total per agent is never shown.

Anyone could create a report showing this values? similar to agent22 in Webview?

Thanks in advance!

Isidro

Where can i download these templates?

Try copying the SQL query and run it directly against the DB. If you see the O/p then its related to CUIC.
 
Also can you point it to AWDB, becasue i have see issues where it will not produce any o/p if you use HDS (as the view needed for the query will be in AWDB, not HDS). To change that, go to that report definition, select the new data source, ceeate the fields, save it. Go bacvk to that report, click edit, you will get an message "Underlying report definiton was changed, click ok to update", here click ok.
 
-senthil
 
 

Hello Luis & Others

Somebody can help me to get the webview report "perskg35: IPCC Peripheral Skill Group Consolidated Half Hour Report"

Thanks in Advance
Rajesh

Thank you Luis, unfortunatly my CUIC is standard edition - somebody can help me by exporting this report in XML format ?

thanks for all your supports

rajesh

Cool, thanks.

Thank you Neil & Luis, its working like a charm...

Cheers / Rajesh

Hi Rajesh

This error is related to divide by zero. So Search for ‘/’ and add nullif

For example… please check below ::

/ nullif(SUM(ISNULL(ASGHH.CallsHandledToHalf,

0)),0),0) ,
avg_duration_incoming_wrap_up_time = ISNULL(( SUM(ISNULL(ASGHH.HandledCallsTimeToHalf, 0)) - SUM(ISNULL

(ASGHH.HandledCallsTalkTimeToHalf, 0)) - SUM(ISNULL(ASGHH.IncomingCallsOnHoldTimeToHalf, 0))) / nullif(SUM(ISNULL(ASGHH.CallsHandledToHalf, 0)),0),0) ,
avg_duration_outgoing_activetime = ISNULL(SUM(ISNULL(ASGHH.AgentOutCallsTalkTimeToHalf, 0)) / nullif(SUM(ISNULL(ASGHH.AgentOutCallsToHalf,


Thanks
Ram

From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
Sent: Monday, April 16, 2012 1:13 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Rajesh CK in Contact Center Reporting (CCR) - Contact Center Reporting: RE: WebView Templates for CUIC

Rajesh CK has created a new message in the forum "Contact Center Reporting":

--------------------------------------------------------------
Hi Neil & Luis

I have successfully imported the report by selecting the historical db, but I have an Issue, the report is not working as expected, its sometime gives DBErrors as follows
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: S0001 Vendor code: 8134 Message: Divide by zero error encountered. } at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:884) at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.runReport(CuicDataProcessingCenterWorkerRunnable.java:297) at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.run(CuicDataProcessingCenterWorkerRunnable.java:117) at com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:88) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) at com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Divide by zero error encountered. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:847) ... 7 more


Its happening when you are selecting a big duration for example a duration of 10hours, i have checked in the source script of the error html file it looks like the below
<script src="/cuic/cues_utility/cues_taglib.js" language="JavaScript"></script><script>cuesKnownLocation='/cuic/';cuesImageFolder='cues_images';cuesIconFolder='cues_icons';cuesVersion='61';cuesXslSkin='base';cuesImageSuffix='';</script><link href="/cuic/tigra/tree.css" rel="stylesheet" type="text/css" /><script src="/cuic/tigra/tree.js" language="JavaScript"></script><script src="/cuic/tigra/cuesDrawer_tree_tpl.js" language="JavaScript"></script><script src="/cuic/tigra/tree_tpl.js" language="JavaScript"></script><script src="/cuic/cues_utility/cues_fonts.js" language="JavaScript"></script><link id="cuesCSS" href="/cuic/cues_utility/cues_taglib.css" rel="stylesheet" type="text/css" /><script src="/cuic/cues_utility/cues_drawn.js" language="JavaScript"></script><script>msgInvalidData="Invalid data has been entered";msgNoncontiguousReorder="You can only reorder selected rows that are contiguous";altExpandDrawer="Expand";altCollapseDrawer="Collapse";altExpandNav="Expand Navigation Pane";altCollapseNav="Collapse Navigation Pane";altExpandTree="Expand tree item";altCollapseTree="Collapse tree item";altLeafTree="Leaf";altWizardStepErrorState="Wizard step contains 1 or more errors";altTabErrorState="Tab contains 1 or more errors";msgEmptyRow="No data to display";altExpandPane="Expand";altCollapsePane="Collapse";altRestorePane="Restore";altInformationalMessage="Informational message";altCriticalErrorMessage="Critical error message";altErrorMessage="Error message";altWarningMessage="Warning message";altSuccessMessage="Success message";var cuesMaskeditFormatError = new Array();cuesMaskeditFormatError["time2"]="The entered time must be in the range of 1:00 to 12:59";cuesMaskeditFormatError["netmask"]="A valid netmask consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3";cuesMaskeditFormatError["ipv6mask"]="Invalid data has been entered";cuesMaskeditFormatError["miltime2"]="The entered time must be in the range of 0:00 to 23:59";cuesMaskeditFormatError["mac"]="A valid MAC address is nn:nn:nn:nn:nn:nn where the 'n's are either digits (0-9) or letters (A-F)";cuesMaskeditFormatError["ipv6"]="A valid IPv6 address is n:n:n:n:n:n:n:n where the 'n's are either digits (0-9) or letters (A-F)";cuesMaskeditFormatError["ipv4"]="A valid IPv4 address consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3";</script>


its not happening always, only for certain intervals, i have checked all the other reports, it all works fine
Please help me to solve the issue

thanks / Rajesh
--
To respond to this post, please click the following link:

<http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/5471259>

or simply reply to this email.

Can anyone confirm something for me...

I know the Reports can be imported on any license but can Report Definitions be imported in CUIC Standard license or does it need to be Premium license?

Thanks for the confirmation

 
PS. I also tried building the report in CUIC as type Stored Procedure and it gave me an error complaining about nested SQL, did not dig into this too much but was thinking some of the temp tables in the original Agent31 SQL were contributing to that error.

Thanks Stefanie,

I went back in just for a sanity check to make sure that was exactly what I had done and when I added the Agent parameter back into the stored procedure on the aw_db on the HDS, and updated the Anonymous Block Query in CUIC to send it, the Value List selection it remembered it from before and had already selected the Agent value list. Also under properties Key Criteria Field was already SkillTargetID. So I am confident those were the steps I took before as well.

Fred