Publishing Data from TM1 to an ODBC source

[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

[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

[cw1194]

Thank you Martin, I will take a look.