Publishing data from TM1 cubes to Relational DBs

Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Publishing data from TM1 cubes to Relational DBs

Post by mce »

Hi,

As I am new in TM1, I have a question for the expers:

- What are the typical methods of exporting data in TM1 cubes to relational databases, such as SQL Server or Oracle DB?
- Is Turbo Integrator capable of exporting TM1 data to such external databases? and if yes, how is it done?

Thanks in advance for replies.

Regards,
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: Publishing data from TM1 cubes to Relational DBs

Post by kpk »

You can use TI. Check the ODBCOutput and Expand TI functions in the reference guide.
You can also export into TEXT (TXT,CSV,...) files and import the data into relational database from there. See ASCIIOutput function.
Best Regards,
Peter
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: Publishing data from TM1 cubes to Relational DBs

Post by kpk »

Best Regards,
Peter
Post Reply