Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: hossam on October 19, 2015, 11:57:59 AM

Title: Datamart Report on 15 minutes aggregation
Post by: hossam on October 19, 2015, 11:57:59 AM

Hi Genesys Gurus :)

I have a bit of a noob question in CCanalyzer reporting.

Using out of the box reports, I can get daily reports detailed on 1 hour level.

How can I report on 15 minutes aggregation level? Do I need a new report? What are the table name that holds the 15 minutes aggregation? Is there any options that I need to modify?

Thanks

Title: Re: Datamart Report on 15 minutes aggregation
Post by: Adam G on October 19, 2015, 12:21:04 PM

If you (still) have the Hyperion RGA (Report Generation Assistant), that is the easiest way to create a new object report based on (any) time period.

You could update and re-point your hourly report to the relevant tables, but that is quite a bit of work...

Title: Re: Datamart Report on 15 minutes aggregation
Post by: hossam on October 20, 2015, 05:22:32 AM

[quote author=adamgill link=topic=9164.msg41235#msg41235 date=1445257264]
If you (still) have the Hyperion RGA (Report Generation Assistant), that is the easiest way to create a new object report based on (any) time period.

You could update and re-point your hourly report to the relevant tables, but that is quite a bit of work...
[/quote]

Thanks for your help.
I still have Hyperion and can still use RGA.

Can you help me identify which table contains 15 minutes aggregation (if any)? Or how to force ETL to do such aggregation?

Thanks

Title: Re: Datamart Report on 15 minutes aggregation
Post by: Adam G on October 20, 2015, 07:34:49 AM

I can guide you - please either PM or email me.

Title: Re: Datamart Report on 15 minutes aggregation
Post by: Kubig on October 20, 2015, 07:43:56 AM

Search for default views with name "R_*_NO_AGG" and use them within the reports