TM1 Forum

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,

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.

A useful post in this topic:
http://forums.olapforums.com/viewtopic.php?f=3&t=2665