TM1 Forum

Morning all,

I have a query about whether it's possible to pivot the measures used within a cube to export these as a single row of data in columns rather than a row for each measure?

At the moment I have 2 measures in the cube, Recharge Amount and a Comment string element. When exporting the data via asciioutput I get a row for each measure, is this even possible? In my head it should be easy but I'm failing miserably!

RSK wrote: I have a query about whether it's possible to pivot the measures used within a cube to export these as a single row of data in columns rather than a row for each measure?

At the moment I have 2 measures in the cube, Recharge Amount and a Comment string element. When exporting the data via asciioutput I get a row for each measure, is this even possible? In my head it should be easy but I'm failing miserably!

Use the Recharge Amount (only the recharge amount) in the subset that is used as part of the source view. In the Data tab, write a CellGetS function to retrieve the corresponding Comment value. Now you can write both out to the text file in the one line.

Alan Kirk wrote:

RSK wrote: I have a query about whether it's possible to pivot the measures used within a cube to export these as a single row of data in columns rather than a row for each measure?

At the moment I have 2 measures in the cube, Recharge Amount and a Comment string element. When exporting the data via asciioutput I get a row for each measure, is this even possible? In my head it should be easy but I'm failing miserably!

Use the Recharge Amount (only the recharge amount) in the subset that is used as part of the source view. In the Data tab, write a CellGetS function to retrieve the corresponding Comment value. Now you can write both out to the text file in the one line.

Thank you so much Alan, much appreciated.