Page 1 of 1
TM1 Drill Through to Oracle
Posted: Tue Dec 14, 2010 9:08 pm
by aagrawal12
Hi Everyone,
Has anybody drilled through to Oracle Web Reports from Tm1 Cube.
Kindly advice some tips of how do we achieve linking from TM1 cube to Oracle Web Reports.
Thanks,
Abhi
Re: TM1 Drill Through to Oracle
Posted: Tue Dec 14, 2010 10:25 pm
by tomok
Is Oracle Web Reports an ODBC-Compliant database? I don't think so. I've never worked with Oracle Web Reports but that sounds like an application or tool in Oracle that lets you build reports on your underlying Oracle databases. TM1 is not going to interface with Oracle Web Reports, the application, but you can certainly build drill-thru connections from a TM1 cube to the underlying database tables in Oracle, assuming you know the structure behind those tables and know how to build the drill-thru SQL to pull back the right stuff.