RFE 65166-Sort Numerically within Dimension/Subset

Suggest and discuss enhancements for TM1
Post Reply
User avatar
gtonkin
MVP
Posts: 783
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

RFE 65166-Sort Numerically within Dimension/Subset

Post by gtonkin » Thu Jan 29, 2015 12:16 pm

If you have elements 1,2,3..10,11,12 and sort these A-Z you get 1,10,11,12,2,3 etc. as the elements are strings.
If you have to add elements without padding leading zeroes, you cannot sort the list easily (dimension order or subset view). Sure you can copy to Excel, delete in subset editor, paste sorted, click manual sort, save etc.

It would be *nice* to have a 0-9, 9-0 type function.
Last edited by gtonkin on Mon Mar 14, 2016 3:39 pm, edited 1 time in total.

lotsaram
MVP
Posts: 3386
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Sort Numerically within Dimension/Subset

Post by lotsaram » Thu Jan 29, 2015 6:51 pm

... but you can have an attribute with the padded leading 0s and use the MDX ORDER function to achieve the desired result? or not?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

User avatar
gtonkin
MVP
Posts: 783
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Sort Numerically within Dimension/Subset

Post by gtonkin » Thu Jan 29, 2015 7:19 pm

it could be done but you really want to have it sorted naturally without going to all the fuss - you just want to "sort anything that looks like a number as a number", one click

User avatar
Alan Kirk
Site Admin
Posts: 6111
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Sort Numerically within Dimension/Subset

Post by Alan Kirk » Thu Jan 29, 2015 7:44 pm

gtonkin wrote:it could be done but you really want to have it sorted naturally without going to all the fuss - you just want to "sort anything that looks like a number as a number", one click
Agreed; it should be basic sort and filter functionality, though I'll admit that the leading zero workaround mentioned by Lotsaram has always worked fine for me. If you submit it through the RFE channel I for one would certainly add my vote to it, though admittedly I think it's more likely to languish in the lower to mid range vote tally.
"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.

User avatar
jim wood
Site Admin
Posts: 3781
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Sort Numerically within Dimension/Subset

Post by jim wood » Thu Jan 29, 2015 8:28 pm

There's many things as long term users that we've just got used to working around. As a developer IBM will see this as something that can be easily worked around. I doubt it will see the light of day. I also agree that this should be in there. For me the A -> Z sort should be intelligent enough to do this anyway.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
gtonkin
MVP
Posts: 783
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Sort Numerically within Dimension/Subset

Post by gtonkin » Fri Jan 30, 2015 5:30 am

RFE has been submitted-RFE 65166

User avatar
Alan Kirk
Site Admin
Posts: 6111
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Sort Numerically within Dimension/Subset

Post by Alan Kirk » Fri Jan 30, 2015 5:50 am

gtonkin wrote:RFE has been submitted-RFE 65166
Vote submitted. But I wouldn't get your hopes up; as Jim said if there's a workaround they probably won't bother with it, especially in Perspectives and Architect. I think the last thing of significance that they did there (if you discount new icons, which I tend to do for some odd reason) is the recently abandoned .Net Rules editor. Beyond that Perspectives / Architect has been the woefully neglected cousin in the Quest For Java.
"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.

User avatar
gtonkin
MVP
Posts: 783
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Sort Numerically within Dimension/Subset

Post by gtonkin » Fri Jan 30, 2015 6:02 am

Thanks for the vote Alan - will check this functionality on CAFE as I am sure between this and PM, developers are hard at work adding features - get an RFE in on these products early enough and who knows (will be clinging to old school TM1 for as long as I have strength though)

User avatar
jim wood
Site Admin
Posts: 3781
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Sort Numerically within Dimension/Subset

Post by jim wood » Fri Jan 30, 2015 2:23 pm

Good plan. If they're linked in any way they may apply to architect at the same time, although I'm not counting any of those chicken I see wandering by. (I'm on medication as I'm sick as a dog at the mo.)
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply