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!
Pivoting Measures
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Pivoting Measures
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.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!
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
RSK
- Posts: 49
- Joined: Mon Oct 08, 2012 12:02 pm
- OLAP Product: TM1 10.1.1
- Version: TM1 10.1.1
- Excel Version: 2010
Re: Pivoting Measures
Thank you so much Alan, much appreciated.Alan Kirk wrote: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.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!