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

2 comments:

  1. 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