Hello again....
The Hyperion installation comes with a standard set of Reports, specifically for Genesys.
As I recall, there is also a "Report Generation Assistant" (RGA) Hyperion Template - basically, you select your Objects (Agent, Agent Group, Queue, Route Point, etc.), then specify the Stats you want and the Aggregation Level and it produces a pre-defined Hyperion Report for you. The only problem with the RGA is if you mess around with the CCA Database (Datamart) Tables and Views or add new Layouts in DMA - it doesn't recognize anything apart from the standard build...
The basis for any Query is to find the 3 Tables from the same DMA Layout which include the Objects, Statistics and Time - usually the T_, O_ and R_ Tables in your Datamart. For example (names may or may not reflect these values);
T_noagg_Agent_Group
O_noagg_Agent_Group
R_noagg_Agent_Group
(the naming conventions are closely tied to the DMA Layout names...)
Connecting the Tables:
O_ to R_ Tables = ObjectID
R_ to T_ = Time Key
Selecting criteria:
From the O_ Table, you might want to use either the PresentationName or the ObjectName - both are similar
From the R_ Table, select the Statistics you want to see on your Results.
From the T_Table, select something like Date_yymmdd to select a date.
Constrain/Optimize your Query criteria:
The Datamart Tables can grow very very big (millions of rows) and, depending on your Database type (SQL or Oracle), your Query may or may not be optimized before it hits the db. So - bear in mind you want to constrain your Query from the outset and make an educated guess at which part of your Query will constrain the results the most. For example;
If you are querying a "no agg" Table, constrain that first - this will mean the Query will extract a small portion of the db Table, prior to applying any other criteria.
Next, work out which will constrain that extract the most - do you have relatively more Stats - or Objects? If you are requesting 10 Stat Types and 30 Objects ("Agents), then send the Stat Types before the Agents within your Query. With these as example, it might look something like:
SELECT [i](Objects, Stats, Times)[/i]
FROM[i] (T_, O_ and R_ Table References)[/i]
WHERE T_no_agg_Agent_Group.Date_yymmdd = "110118"
AND O_no_agg_Agent_Group = "AG1" OR "AG2" OR "AG3" OR "AG4" OR "AG5" OR "AG6" OR "AG7" OR "AG8" OR "AG9"OR "AG10"
- in this way, the db engine has the least work to do, even if there are no optimization techniques applied on it.
Phew!
- hope this helps?
TT
