This content has been marked as final. Show 6 replies
The best place is to start reading the documents related to IR. They can be found here: http://docs.oracle.com/cd/E17236_01/nav/portal_4.htm
I've never built an IR report, but I heard its connection to Essbase is not so good. We just upgraded our Hyperion apps to 220.127.116.11, so I am not sure if there has been any changes. I know relational database knowledge is key to building IR reports. That's probably why I've stayed away from it :)
Hope this helps.
IR is pretty good to be used with RDBMS but not very good with Essbase.....You may prefer Financial Reporting or Web Analysis for querying Essbase.
IR will use ODBC drivers which is provided with IR installation or native database client to connect to the database.
Thank you VC!
VC, If you are aware, could you explain me how is the data extracted from RDMS for reporting through the IR? Is it only through SQL or do we have some third party tools or something like the EIS(Essbase Integration services which is used for loading data into Essbase cubes)?
Could someone explain me the end to end process with IR if the source is an RDMS?