Saturday, May 4, 2013

How to export TM1 data using Turbo Integrator

This document is based on Cognos version 10.2 and TM10.1.1
Step 1: Create a cube test1

Step 2: create a default view as ALL to hold all data
Step 3: create a TI process using cube view
Step 4: set variables, variable type = String, and Contents=Other
Step 5: add TextOutput in MetaData to loop through all available  data
Step 6: Check exported data
Posted by at
Labels:

4 comments:

  1. AnonymousFebruary 23, 2017 at 3:29 AM

    Hi,
    i have one question here. What if the output is needed in denormalised form. What i mean is to have months in column instead of in rows.
    I have been trying to export a csv having all measures in column. it is giving multiple records(repeated).
    thanks!

    ReplyDelete
  2. DiniApril 18, 2017 at 11:34 PM

    Thanks heaps

    ReplyDelete
  3. AnonymousApril 20, 2018 at 12:39 AM

    How to export the data and insert into database table. This can eliminate a step export to file and then process the file to database table. any risk or challenges direclty inserting the Tm1 data export to releational table.

    ReplyDelete
  4. veeraMay 9, 2020 at 3:47 AM

    thanks for sharing this blog

    ReplyDelete

Subscribe to: Post Comments (Atom)