Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: amine.riahi.idrissi on April 28, 2015, 03:09:15 PM

Title: GIM report
Post by: amine.riahi.idrissi on April 28, 2015, 03:09:15 PM

how can i get data from GIM_etl database ?? without the use of GI2?? :( :( :( :(

Title: Re: GIM report
Post by: Kubig on April 29, 2015, 06:31:57 AM

In general : Directly from the database. GIM is just a aggregator engine, which prepares source data that you can use within any relevant GUI, such as II or any custom. In this way, there is no different from CCA solution. There was a Hyperion as a suggested tool, but not only this one.

Title: Re: GIM report
Post by: smile on April 29, 2015, 01:21:41 PM

Try Jasperreports, but you will need read and understand gim datamodel and then configure it in jasper report generator. The main advantage of gi2 is that you can use already prepared reports or create a new one using already defined data model (universe).

Title: Re: GIM report
Post by: amine.riahi.idrissi on May 07, 2015, 09:36:48 AM

Thanks i'll use crystal reports to get data from the etl directly from the fact tables and dimensions  ::) ???

Title: Re: GIM report
Post by: Adam G on May 07, 2015, 11:16:56 AM

To my understanding, Fact and Dimension Tables are derivatives of the ETL process, for GIM.  Your statement sounds like you want to access those Tables(?)  So, it depends what are you trying to do...

To get unaggregated data, access ETL.  This will be raw data and you will have to add in your own aggregations and "join" the necessary parts, to create your own Facts and Dimensions.
To get Fact and Dimension Table data, access GIM - because that is what it does!

If it is a question of accessibility, then connect a BI/MI Tool to the Schema/Universe available in GIM Database for Facts and Dimensions.

Title: Re: GIM report
Post by: amine.riahi.idrissi on May 07, 2015, 10:50:03 PM

i mean the GIM database (Facts and dimensions)