Hi All
Has anyone come across the order of the data that gets exported is not the same as the order of elements in the dimension ?
Static subset is created through TI prior to exporting the data out.
ASCIIOUTPUT data
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: ASCIIOUTPUT data
If memory serves this something that can be found in the known issues forum. I might be wrong however. Have a look in there,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Regular Participant
- Posts: 180
- Joined: Thu Jul 01, 2010 3:06 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2007
- Location: Melbourne, Australia
Re: ASCIIOUTPUT data
http://blog.tm1tutorials.com/tag/asciioutput/
Found this posted by Wim Gielis
"The aim is to export a list of projects that generated revenues in a chosen year, but sorted by project name in column A. The project name is an alias on the project number element names. It is possible to create a subset containing projects at n level, showing the alias, and sorted on that alias. It is possible to assign this custom subset to a view. But when TM1 processes the view, he pays no attention to ordered subsets whatsoever."
Wim did mention on the post that it ignores the order of the subsets when exporting the data. Abit surprise that such functionality is not found in the TM1 process. Do you know if such problem still exist in the latest Tm1 10.2 ?
Found this posted by Wim Gielis
"The aim is to export a list of projects that generated revenues in a chosen year, but sorted by project name in column A. The project name is an alias on the project number element names. It is possible to create a subset containing projects at n level, showing the alias, and sorted on that alias. It is possible to assign this custom subset to a view. But when TM1 processes the view, he pays no attention to ordered subsets whatsoever."
Wim did mention on the post that it ignores the order of the subsets when exporting the data. Abit surprise that such functionality is not found in the TM1 process. Do you know if such problem still exist in the latest Tm1 10.2 ?
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: ASCIIOUTPUT data
I doubt that's something that's changed. Hopefully if Wim see's this he may have tested it within 10.2 and will have a better idea of where this is,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: ASCIIOUTPUT data
Don't you mean "the data that gets exported is not the same is the order of the subset"???? When you process a view as a TI data source, regardless of whatever subsets you may be using, the data is processed according to the index number of the actual elements in each dimension and from Dimension 1 to Dimension x order. If you want to control the order yourself you would have to skip using a view as a data source and write code in the Prolog to loop through the subsets yourself and use a combination of CellGets and ASCIIOutputs to achieve what you want.winsonlee wrote:Hi All
Has anyone come across the order of the data that gets exported is not the same as the order of elements in the dimension ?
Static subset is created through TI prior to exporting the data out.
-
- Regular Participant
- Posts: 180
- Joined: Thu Jul 01, 2010 3:06 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2007
- Location: Melbourne, Australia
Re: ASCIIOUTPUT data
Yes, you are right, i am actually reffering to the order of the subset.
That would mean the best option now is to export the data out via prolog.
The only disadvantage of looping through the subset is not being able to supress zero.
That would mean the best option now is to export the data out via prolog.
The only disadvantage of looping through the subset is not being able to supress zero.
-
- MVP
- Posts: 3117
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: ASCIIOUTPUT data
Tom is correct.
And in TM1 10.2, this still holds true. No possibility to export in a quick way, taking advantage of views skipping non-existant data points.
But honestly, I don't get asked for this type of solutions often. Once a year or so, and then I use a batch process to do some kind of sorting afterwards, after the initial text file was created by TM1.
And in TM1 10.2, this still holds true. No possibility to export in a quick way, taking advantage of views skipping non-existant data points.
But honestly, I don't get asked for this type of solutions often. Once a year or so, and then I use a batch process to do some kind of sorting afterwards, after the initial text file was created by TM1.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly