ssasbusiness-intelligencecognoscognos-bicognos-tm1

Exporting Data from a cube to Database using Turbo Integrator (ibm cognos TM1)


I am using Turbo Integrator for the first time to export data from a tm1 cube to a database. I know that for exporting data to a file we can use something like this :

ASCIIOUTPUT( zFile, 'Dim1','Dim2','Amount');

But I would love to know the syntax used to export it to a database ?

Thank you in advance


Solution

  • I don't know which TM1 (IBM Planning Analytics) Version you are using. Maybe this info can help you. It's for version 2.0.x:

    Open an ODBC-connection: ODBCOpen(Source, ClientName, Password);

    Write your output as SQL: ODBCOutput(Source, SQLQuery, [SQLQuery2, SQLQuery3, ...]);

    Close the ODBC-Connection: ODBCOutput(Source, SQLQuery, [SQLQuery2, SQLQuery3, ...]);

    An other way is to do it by command. You could write an batch file an run it by a TI-process

    ExecuteCommand(CommandLine, Wait);
    

    You can find additional information on the IBM Webside: IBM Knowledge Center