" /> Datamart Report on 15 minutes aggregation - Genesys CTI User Forum

Author Topic: Datamart Report on 15 minutes aggregation  (Read 2453 times)

Offline hossam

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
Datamart Report on 15 minutes aggregation
« on: October 19, 2015, 11:57:59 AM »
Advertisement
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

Adam G

  • Guest
Re: Datamart Report on 15 minutes aggregation
« Reply #1 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...

Offline hossam

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
Re: Datamart Report on 15 minutes aggregation
« Reply #2 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

Adam G

  • Guest
Re: Datamart Report on 15 minutes aggregation
« Reply #3 on: October 20, 2015, 07:34:49 AM »
I can guide you - please either PM or email me.

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: Datamart Report on 15 minutes aggregation
« Reply #4 on: October 20, 2015, 07:43:56 AM »
Search for default views with name "R_*_NO_AGG" and use them within the reports