CUIC 10.5 Report output interval

[chad_meyer]

Hey everyone, I have a question regarding the output interval of reports.  We are running CUIC 10.5.1 Standard and currently have a report that runs a daily view but has the information broken down in 15 minute intervals.  I am wondering if there is a way to change the value to an hour, not 15 minutes.  

I ran the SQL query output into Management Studio and see where CTI.ReportingInterval is defined as 900 seconds (15 minutes), but can't see how to change that time and export the results.  

Any help would be appreciated.  Thank you. 

[Deepak Rawat · Accepted solution]

Chad,

You can definitely do this but you will need a standalone CUIC server with Premium license to do so. You will need to export the Stock Report for which you want to make the changes into the standalone premium CUIC. You will be prompted that the Report Definition does not exist, and will need to be created.  Choose the UCCX Datasource when prompted to allow this to happen.

You’ll now see Agent State Summary by Interval Report (just an example, in your case it will the report you want) available on CUIC Premium in the Reports drawer.  Also, you will see this report’s definition has been created in Imported Report Definitions, in the Reports Definitions drawer. Finally, you’ll see that the all the relevant UCCX Value Lists now exist on CUIC Premium.  We need to create a new one, so we do that here.  We’ll call it Custom_Interval_Lengths.  The Value List Query written here is based on the original Value List UCCX_Interval_Length, but we will need to add the 60 minute interval as per our requirement.

Next, we will make use of this custom Value List through a Report Definition.  Open the Agent State Summary by Interval Report (just an example, in your case it will the report you want) Definition under Imported Report Definitions.  On the Parameters tab, Edit @param3, which is Interval Length.  From the drop down, change the Value List from UCCX_Interval_Length to Custom_Interval_Lengths. 

Now that you have the custom report definition using the custom value list, you will need to create a report to use this. Open the reports drawer and in the right hand right click on Reports and choose Create Report.  Name the report, and choose your new Report Definition from the choices. Go ahead and run your report on CUIC Premium to confirm that the 60 Minute Interval Length is available, and that the report generates results as expected when run from this server. Now go ahead and export the Custom Report by right clicking on it from the Reports drawer. Save the exported report as a ZIP, just like we did when exporting the original stock report from UCCX. Going back to UCCX CUIC, the next step is to import the custom report.  Click the Report drawer on the left, and use the Import button just like you did to Import the stock report into CUIC Premium.

You will be prompted that the Report Definition needs to be created.  Just like the Stock Agent State Summary by Interval report definition was created on CUIC Premium when you imported the Stock Report, the Custom Agent State Summary report definition gets created on UCCX. You won’t be able to see the Report Definition on UCCX, but it will be created.

Navigate to Value List, you’ll see the custom value list created on CUIC Premium is now on UCCX. The custom report will now exist on UCCX CUIC, and you will able to run the Agent State Summary by Interval with 60 minute intervals!

Attaching the Report Developer Guide as well that you can use a reference to create Data Source etc.

Regards

Deepak

- Rate Helpful Posts -

[chad_meyer]

Thanks Deepak, very thorough.  Does this guide apply to CUIC for CCE as well?  We have migrated away from UCCX.

[Deepak Rawat]

With UCCE, you will have a standalone CUIC and not a co-resident one, will apply there as well.

Regards

Deepak

- Remember to Rate Helpful Posts -

[Michael Martin]

Deepak

Is it possible to add a Custom Interval Length of 1440 minutes as a value to  reflect 1 day - i have a request to emulate an Avaya report that breaks out a CSQ in a 24 hour format. the request is to be able to select multiple days and get summary per day - If i select the entire range the UCCX report combines all the days as 1.

When i create a custom interval length and enter the values "select 1440 as ID,'1440(1440) Minutes' as value from table(set{1})"  without quotes, i get an error "Invalid Value List query. A syntax error has occured".

[bill.king1]

Wouldn't it be easier to run the report and adjust the grouping instead to add a group by day for instance?