COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: DougMAN on 23 Jul 2010 02:18:50 PM

Title: can i export an xml file using Turbo Integrator.
Post by: DougMAN on 23 Jul 2010 02:18:50 PM


I am trying to export an xml file out of TM1 using Turbo Integrator.

1)      Question 1

As you know to export a sample csv file,
It is;
TextOutput('TextPutput.csv', Subsidiaries, Channels, Products, Months, Versions, Sales_plan_measures,value);


What would be the command for xml?

2) Question 2

Measure                             Value
Total                               24732.073
Mobil                                  0
Peacetime Operating              19131.341
Peacetime Other                    5600.732




My question is I need Measure and value  data to come out of the system like;



Total        Mobil           Peacetime Operating    Peacetime Other

24732.07  0                         19131.34                          5600.732



Is there a command to do this.

Thanks for your help,  Doug.





























                     
                     









Title: Re: can i export an xml file using Turbo Integrator.
Post by: dusherwo on 28 Jul 2010 11:23:51 AM
1)  TM1 doesn't support XML output.
2)  TM1 processes a cube view one cell at a time. To get the kind of output you want, restrict the source view to the Total element, add cellgetn's for the other elements, then build up your asciioutput string from them.
HTH