Publishing Data from TM1 to an ODBC source

Post Reply
cw1194
Posts: 10
Joined: Fri Sep 12, 2008 4:19 pm

Publishing Data from TM1 to an ODBC source

Post by cw1194 »

I was interested in knowing if there is a way to take data from a cube and to publish it into a source like MS Access. If this is possible can someone please show me how this is done or where to find out how?

Thanks
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Publishing Data from TM1 to an ODBC source

Post by Martin Ryan »

Hi CW,

Something along the lines of this put into TI should work. Note you'll need to set up the ODBC connection first

Code: Select all

In the Prolog
Source='ODBCDestn';
ClientName='user';
Password='pword';
ODBCOpen(Source, ClientName, Password);

In the Data tab
SQLStatement='your sql statement';
ODBCOutput(Source, SQLStatement);
SQLStatement='your sql statement';
ODBCOutput(Source, SQLStatement);
SQLStatement='your sql statement';
ODBCOutput(Source, SQLStatement);

In the Epilog
ODBCClose(Source);
HTH,
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
cw1194
Posts: 10
Joined: Fri Sep 12, 2008 4:19 pm

Re: Publishing Data from TM1 to an ODBC source

Post by cw1194 »

Thank you Martin, I will take a look.
Post Reply