" /> How to Optimize Brio Reports... - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: How to Optimize Brio Reports...  (Read 6306 times)

This topic contains a post which is marked as Best Answer. Press here if you would like to see it.

tony

  • Guest
How to Optimize Brio Reports...
« on: July 15, 2009, 02:40:45 PM »
Advertisement
I was going to post quite a large chunk of text here, regarding how to optimize Brio Queries.  I'll do that, if there is any interest in the subject...  ;D

Tony
Logged

tony

  • Guest
Re: How to Optimize Brio Reports...
« Reply #1 on: July 19, 2009, 09:07:18 PM »
...that'll be a "no", then...  ;D
Logged

Offline Adam G.

  • Hero Member
  • *****
  • Posts: 552
  • Karma: 12
  • Still Gorgeous.......
Re: How to Optimize Brio Reports...
« Reply #2 on: July 19, 2009, 09:36:02 PM »
Tony,

How about we do a some reports based around an OSS reporting solution like JasperReports? [url=http://jasperforge.org/]http://jasperforge.org/[/url]

Reports could be done for both CCA and Infomart.

Pavel

Logged

tony

  • Guest
Re: How to Optimize Brio Reports...
« Reply #3 on: July 20, 2009, 12:06:10 PM »
Pavel - that's a bit off-topic but I'm downloading it now, for "evaluation"... lol
Logged

KBS

  • Guest
Re: How to Optimize Brio Reports...
« Reply #4 on: July 20, 2009, 12:10:34 PM »
Tony -
what about a high-level review of different reporting/BI solutions and the benefits/perceived downfalls on each, with respect to the Genesys environment? For example, touch on DBs supported, type of database connections, ease of use, support options/availability, training options/availability, strengths, weaknesses, etc?
I'm not a reporting guru, and have my own opinions re: Brio/Hyperion, but am looking for a replacement  that either (a) I can install and then instruct users on how to use it , or (b) I can install and send the users off to training for.
Logged

tony

  • Guest
Re: How to Optimize Brio Reports...
« Reply #5 on: July 20, 2009, 02:02:25 PM »
I think every BI Reporting tool has it's good and bad points - within the context of Genesys, many moons ago Brio was offered with canned reports and a Report Generation Assistant, configured for Genesys.  This, coupled with the training that was on offer from Genesys. indicated to me that Genesys intended the use of Brio by which to run Datamart Reports.  This is the reason I have concentrated on Brio - and not some other tool, for comparison.

I agree - we [i]could [/i] do a comparison but, being that Brio/Hyperion are [b]not [/b] Genesys tools, then it is fair to say that you could use [i]any [/i] tool (Crystal, Jasper, BusinessObjects...)

Generally, I'm happy to stick with Hyperion/Brio for Datamart and possibly touch on BusinessObjects for Infomart, since these were/are the tools intended by Genesys...

Does that sound fair?

T
Logged

tony

  • Guest
Re: How to Optimize Brio Reports...
« Reply #6 on: July 21, 2009, 12:21:35 PM »
:::UPDATED:::

Starter for 10 points....

Does anyone think that this SQL is formatted for optimal performance, when running from Brio to an Oracle Datamart?

Items in [i]italics [/i] are variables....

SELECT
    AL1."PRESENTATION_NAME",
    AL2."T_LOGIN",
    AL2."T_TALK",
    AL2."T_WAIT",
    AL2."T_WORK",
    AL2."N_INBOUND",
    AL2."T_INBOUND",
    AL2."T_HOLD",
    AL2."T_NOT_READY",
    AL2."T_OUTBOUND",
    AL2."N_OUTBOUND",
    AL3."DATE_YYYYMMDD",
    AL3."TIME_HH24MI",
FROM
    "[i]MART[/i]"."[i]O_VIEW_OR_TABLE_AGGLEVEL[/i]" AL1, [color=red]<Contains 3708 Rows of Data[/color]
    "[i]MART[/i]"."[i]R_VIEW_OR_TABLE_AGGLEVEL[/i]" AL2, [color=red]<Contains 3194000 (+!) Rows of Data[/color]
    "[i]MART[/i]"."[i]T_VIEW_OR_TABLE_AGGLEVEL[/i]" AL3 [color=red]<Contains 8783 Rows of Data[/color]
WHERE
(AL3.DATE_YYYYMMDD = '[i]YYYYMMDD[/i]'
AND AL3.TIME_KEY = AL2.TIME_KEY)
AND (AL1.PRESENTATION_NAME = '[i]OBJECT_NAME[/i]'
AND AL2.OBJECT_ID = AL1.OBJECT_ID)

???

T
« Last Edit: July 21, 2009, 02:41:53 PM by Tony Tillyer »
Logged
Marked as best answer by on Today at 07:51:54 PM

Offline ecki

  • Sr. Member
  • ****
  • Posts: 329
  • Karma: 8
Re: How to Optimize Brio Reports...
« Reply #7 on: July 21, 2009, 03:44:34 PM »
  • Undo Best Answer
    • Hi Tony,

    I think the biggest table should be in the last position. However the real magic would be in indexing. I do not remember now from memory what indexes CCA is using or if at all.

    Cheers.

    e.
    Logged
    Pages: [1]   Go Up
    « previous next »