Page 1 of 1
Publishing Data from TM1 to an ODBC source
Posted: Wed Oct 15, 2008 2:59 pm
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
Re: Publishing Data from TM1 to an ODBC source
Posted: Wed Oct 15, 2008 3:03 pm
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
Re: Publishing Data from TM1 to an ODBC source
Posted: Wed Oct 15, 2008 3:06 pm
by cw1194
Thank you Martin, I will take a look.