Order of Subsets

Post Reply
erik664
Posts: 18
Joined: Fri Mar 08, 2013 6:11 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007

Order of Subsets

Post by erik664 »

Is there any way to rearrange the order of subsets besides the default alphabetical sort?

I've created subsets of elements for a dimension where the elements correspond to a certain month, so the subsets are named after months. But when sorted alphabetically, it puts 'April' first. Is there any way to change the order? I know I could get around this by prefixing the subsets with the number of the month, but I was just wondering if there was another way.

Thanks,
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Order of Subsets

Post by David Usherwood »

Several.... :)
Sort by index
Write MDX to get the order you want
Write TI to get the order you want
Copy/Paste (including in and out of Excel)
Drag and Drop
erik664
Posts: 18
Joined: Fri Mar 08, 2013 6:11 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007

Re: Order of Subsets

Post by erik664 »

David Usherwood wrote:Several.... :)
Sort by index
Write MDX to get the order you want
Write TI to get the order you want
Copy/Paste (including in and out of Excel)
Drag and Drop
I'm talking about the subsets themselves, not the elements...
tomok
MVP
Posts: 2836
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: Order of Subsets

Post by tomok »

erik664 wrote:[I'm talking about the subsets themselves, not the elements...
No.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Order of Subsets

Post by Duncan P »

Dorothy Parker, seated next to Calvin Coolidge at a dinner, said to him, "Mr. Coolidge, I've made a bet against a fellow who said it was impossible to get more than two words out of you." His famous reply: "You lose."
User avatar
wissew
Posts: 54
Joined: Tue Jun 17, 2008 7:24 pm
OLAP Product: TM1
Version: 9.5.2; 10.2.2; 11
Excel Version: 2003 SP3 - 2013
Location: Beaverton, OR

Re: Order of Subsets

Post by wissew »

You could try prefacing the month name with the code, 01-Jan, 02-Feb,...
Post Reply