New Reporting Project

[Adam G.]

Hello Everyone,

I'm thinking about starting an 'open source' MIS reporting project for Genesys. You'll still need CCA, Infomart etc to collect the data but this project will be extract and present the data. Think of it as a replacement in one for Brio\Hyperion and an alternative to using Business Objects for Infomart.

Here are some of the main guiding principles i'm thinking off:
[list]
[li]Based on a mature open source MIS product[/li]
[li]Report files freely downloadable.[/li]
[li]Report source code is freely modifiable[/li]
[li]Hosted here on the Forum (is this OK Vic?)[/li]
[/list]

Basically it would permit you to implement a free and flexible MIS system unencumbered by licensing restrictions\costs.

What does everyone think?

Pavel

[tony]

I'm in...

Assuming we're thinking of using Jasper?

T

[Adam G.]

[quote author=Tony Tillyer link=topic=4557.msg20252#msg20252 date=1249989378]
I'm in...

Assuming we're thinking of using Jasper?

T
[/quote]

Shhhhhhh... I'm still evaluating it.

[tony]

<quietly> I already did - a bit sticky though - not sure it likes data tables from different databases, since it only seems to connect to one data source at a time... if your cfg is seperate from your mart... </quietly>

T

[tony]

[b]Pavel!!!!!![/b]

...so....?

T

[tony]

How about some groundwork... or some definitions...?

Aims?
Naming Conventions?
Objects?
Stats?
Aggregatiions?
Report Types?

I'm brimming with them, today...!

T

[Adam G.]

Wow Tony (have you been drinking the Red Bull again)? 

(sorry I've been a little busy on my Manhattan Project for Genesys  )

My plan is to start by cloning some of the Brio\Hyperion canned reports using JasperReports [url=http://jasperforge.org/]http://jasperforge.org/[/url]. This would naturally develop the naming conventions etc

Pavel

[mark]

I would happily support any project that would mean giving something better than Brio / Hyperion.

[tony]

Okay... how about:

[i]AIM: "To provide an alternative means of volume reporting from the Genesys Datamart, using standardized open source tools and methods"[/i]

Using JASPER to provide out of the box ("canned") reports for:

SQL
Oracle

Object coverage:

(All or Selected) Agents
(All or Selected) Agent Groups
(All or Selected) Route Points
(All or Selected) (Virtual) Queues
(All or Selected) Skills

Stat Coverage:

Dependant on Objects(!)

Aggregations:

NOAGG (15 Minutes)
HOURLY
DAILY
WEEKLY
MONTHLY
QUARTERLY
ANNUAL

...is this a good start?

T

[Adam G.]

[quote]
AIM: "To provide an alternative means of volume reporting from the Genesys Datamart, using standardized open source tools and methods"
[/quote]


AIM: "To provide an alternative [b]and customisable[/b] means of volume reporting from the Genesys Datamart, using standardized open source tools and methods"

[tony]

Of course!

How about these, for starters...?

[b]Agent/Agent Group:[/b]

[b]Volume Totals: [/b] N_Inbound, N_Outbound, N_Internal, N_Transfers_Out, N_Transfers_In, N_Consult and N_Unknown, N_Inbound, N_Outbound, N_Internal, N_Transfers_Out, N_Transfers_In, N_Consult, N_Unknown, N_Wait, N_Ringing, N_Hold and a number of pre-defined KVP/Filters

[b]Time: [/b] Total_Login_Time, Total_Work_Time, Total_Talk_Time, Total_Talk_Time_Inbound, Total_Talk_Time_Outbound, Total_Talk_Time_Internal, Total_Talk_Time_Consult, Total_Talk_Time_Transfer_Out, Total_Talk_Time_Transfer_In, Total_Time_Unknown, Total_Hold_Time, Total_Ringing_Time, Total_Dial(l)ing_Time and Total_Wait_Time and a number of pre-defined KVP/Filters

[b]Route Points:[/b]

[b]Volume Totals: [/b] N_Entered, N_Abandoned, N_Answered, N_Distributed, N_Abandoned_Ringing, N_Unknown and a number of pre-defined KVP/Filters

[b]Time:[/b] Max_Time_To_Answer, Max_Time_To_Abandon, _Max_Time_To_Abandon_From_Ringing, Total_Time_To_Answer, Total_Time_To_Abandon, Total_Time_To_Abandon_From_Ringing and a number of pre-defined KVP/Filters

[b]Queues:[/b]

[b]Volume Totals: [/b] N_Entered, N_Abandoned, N_Answered, N_Distributed, N_Abandoned_Ringing, N_Unknown and a number of pre-defined KVP/Filters

[b]Time: [/b] Max_Time_To_Answer, Max_Time_To_Abandon, _Max_Time_To_Abandon_From_Ringing, Total_Time_To_Answer, Total_Time_To_Abandon, Total_Time_To_Abandon_From_Ringing and a number of pre-defined KVP/Filters

[b]Skills:[/b]

As for Agent/Agent Groups

?

T

[Adam G.]

Tony,

You just volunteered to be the documenter!

Good list to start with. I think I'll attack the Queues report first.

Pavel

[Adam G.]

[quote author=Tony Tillyer link=topic=4557.msg20254#msg20254 date=1249989731]
<quietly> I already did - a bit sticky though - not sure it likes data tables from different databases, since it only seems to connect to one data source at a time... if your cfg is seperate from your mart... </quietly>

T


[/quote]

The use of subreports allows connecting to alternative datasources 

[tony]

Had we thought about Call Concentrator - AREC, SCDR, QINFO? ...and perhaps LOGIN...?

Too much..?

T

[Adam G.]

Tony,

I'm certainly getting my head around Jasper Reports and it's almost too flexible.... I'm getting close to finishing a Q report. 

The number one priority is a replacement for the CCA canned reports. Thereafter the options are (in no specific order):
(1) Infomart reports
(2) Call Con reports
(3) 'Other' reports\uses - I'm thinking dashboards for supervisors, dashboards for agents and the big idea a dashboard suitable for plasma\LCD screens to replace wallboards.

Have I missed anything?

Pavel