GIM report

[amine.riahi.idrissi]

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

[Kubig]

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.

[smile]

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

[amine.riahi.idrissi]

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

[Adam G]

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.

[amine.riahi.idrissi]

i mean the GIM database (Facts and dimensions)