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,
Publishing data from TM1 cubes to Relational DBs
-
- 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
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.
You can also export into TEXT (TXT,CSV,...) files and import the data into relational database from there. See ASCIIOutput function.
Best Regards,
Peter
Peter
-
- 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
A useful post in this topic:
http://forums.olapforums.com/viewtopic.php?f=3&t=2665
http://forums.olapforums.com/viewtopic.php?f=3&t=2665
Best Regards,
Peter
Peter