How to Optimize Brio Reports...

[tony]

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... 

Tony

[tony]

...that'll be a "no", then... 

[Adam G.]

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

[tony]

Pavel - that's a bit off-topic but I'm downloading it now, for "evaluation"... lol

[KBS]

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.

[tony]

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

[tony]

:::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

[ecki]

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.