TM1 10.2 connection to DWH

Post Reply
Danny
Posts: 2
Joined: Wed Jun 10, 2015 12:45 pm
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2010

TM1 10.2 connection to DWH

Post by Danny »

Hello,

am looking for ways to connect TM1 10.2 with a relational database. Have been checking the TM1 Performance Modeler User Guide and TM1 Developer Guide without success.

The idea behind that is: I wanna design a planning solution with TM1. For that I need to import referential data from a DWH into a TM1 cube (this should be possible by "guided Import" in performace modeler). I also want to write back the palnning results to the relational database (so far I've no idea on how to tackle this part).

Don't necessary need extermly detailed information at this point in time, am rather trying to get a general idea on how that works.

Any hints are highly appreciated.

Best regards
Danny
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 10.2 connection to DWH

Post by tomok »

Read the documentation about TurboIntegrator, that's the tool you would use.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: TM1 10.2 connection to DWH

Post by BrianL »

More specifically, the ODBCOutput TI function and other related calls/configs.
Danny
Posts: 2
Joined: Wed Jun 10, 2015 12:45 pm
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2010

Re: TM1 10.2 connection to DWH

Post by Danny »

Thanks a lot!
Post Reply