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
TM1 Drill Through to Oracle
-
aagrawal12
- Posts: 21
- Joined: Thu Nov 05, 2009 8:56 am
- OLAP Product: TM1
- Version: 9.4.1 9.5.1 9.5.2 and 10.2.2
- Excel Version: 2003 2007 and 2010
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: TM1 Drill Through to Oracle
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.