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