Page 1 of 1

TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 19, 2016 11:03 am
by wigglyrat
Hi:

I am trying to set a dimension order manually however after rearranging the dimensions in dimension editor, selecting 'set dimension order' and then 'Dimension' 'Save' it will not preserve the order.

Each time I go in to look, the order of the elements reverts back to the original order before the reordering.

I am trying this in Perspectives, but have also tried in Performance Modeler using 'move up' and 'move down' but have the same result.

Has anyone else experienced this?

Many thanks,

Re: TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 19, 2016 11:49 am
by AmbPin
Hello,
I think the order that you are seeing is the order in which elements were added to the dimension (The index) and therefore this will not generally be affected by you moving them around in the editor.

Re: TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 19, 2016 12:06 pm
by wigglyrat
Yes, I think so.

Is there no way to change this then?

It is for a time hierarchy - so my users are not happy to see July before June.

Many thanks for your assistance.

Re: TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 19, 2016 12:16 pm
by tomok
You can put the elements in any order you want if you do it through an XDI workbook.

Re: TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 19, 2016 12:42 pm
by wigglyrat
Many thanks for this.

I see that you can create dimensions using xdi/dimension worksheets, but can you create an xdi from an existing dimension if it was not originally built with one?

Kindest,

Re: TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 19, 2016 12:52 pm
by jim wood
Yes you can. I would read through how to create a dimension using an XDI. Keep in mind your local server setting etc. Especially if you want multiple people editing the dimension. Another option is to recreate it using a CSV and TI. If you set the order in the TI or even within your CSV you should be good. Hopefully this will then be a one off exercise.

Re: TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 19, 2016 1:19 pm
by AmbPin
There are various sorting options available to you via MDX also if you wanted to create some dynamic subsets.

Re: TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 19, 2016 1:33 pm
by tomok
wigglyrat wrote:Many thanks for this.

I see that you can create dimensions using xdi/dimension worksheets, but can you create an xdi from an existing dimension if it was not originally built with one?

Kindest,
Right click on dimension and choose Export Dimension. This will create a CSV version of what the XDI would look like to create that exact same dimension. Open the file in Excel with Perspectives loaded, move the elements around to get the desired order, then save as an Excel workbook with the name "YourDimensionName,xdi". Don't forget the quotes around the name or otherwise you'll get a file name of YourDimensionName.xdi.xlsx. You can save the dimension on the server by choosing TM1, Developer, DImension Save.

FWIW, any time I have a smallish dimension that has to be in a specific order, that is not alpha sortable, then I use an XDI to ensure I get the dimension ordered exactly as I want it. As others have stated, you CAN accomplish this through TI but it's not nearly as easy if you have an already existing dimension.

Re: TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 19, 2016 3:16 pm
by wigglyrat
All very helpful, thank you for your replies.

Re: TM1 'Set Dimension Order' Not Working

Posted: Sun Feb 21, 2016 12:25 am
by paulsimon
Hi

I would also check the }DimensionProperties cube for that dimension to see if any Sort Order has been stored there.

Regards

Paul Simon

Re: TM1 'Set Dimension Order' Not Working

Posted: Fri Feb 26, 2016 6:51 am
by babytiger
Is there a default subset created for this dimension? Is it possible that you were looking at the default subset order instead of the indexed order?

Re: TM1 'Set Dimension Order' Not Working

Posted: Thu Oct 04, 2018 10:21 am
by Xavier 13
Hello,

I found this topic for the same issue, the button "Set Dimension Order" seams not to be working. It does, but you need to save changes to the structure of the dimension before.

Arrange your elements.
Press "Set Dimension Order" button
Save your changes
Then only re-open the dim editor and your elements indexes will be correct.

Re: TM1 'Set Dimension Order' Not Working

Posted: Thu Oct 04, 2018 10:26 am
by Wim Gielis
Xavier 13 wrote: Thu Oct 04, 2018 10:21 am Hello,

I found this topic for the same issue, the button "Set Dimension Order" seams not to be working. It does, but you need to save changes to the structure of the dimension before.

Arrange your elements.
Press "Set Dimension Order" button
Save your changes
Then only re-open the dim editor and your elements indexes will be correct.
Thanks for posting. But isn't it normal behaviour that you save (or cancel) the changes you make - in this case dimension changes ?
If you don't save, TM1 will ask you anyway.

Re: TM1 'Set Dimension Order' Not Working

Posted: Mon Oct 15, 2018 12:29 pm
by Xavier 13
Well it's stupid but I was keeping the subsets editor open and was expecting to see the index changing in the details panel right away after I pressed the button.