can i export an xml file using Turbo Integrator.

[DougMAN]

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.





























                     
                     

[dusherwo]

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