TM1 Forum

I know this can be done with MDX, but if you're using MDX this command would be handy. We have it in the subset editor and we DimensionSortOrder, so why not do the same for subsets??

Jim.

I can't see this idea flying. A subset is an ordered list of elements. Change the order of any of the elements and it is no longer the subset you started with.
Or maybe I just don't get the point?

Why does changing the order change the subset? If you create a list of 10 elements then order them alphabetically it's still the same 10 elements. I came across this as I'm creating a filtered list of elements to use for data validation. When finding a variance and exporting the details to a file it would have been nice if they were alphabetically ordered. As I mentioned you can do it in the subset editor easily (and I know you can do it with MDX) so why not have a command to do so?

jim wood wrote:Why does changing the order change the subset? If you create a list of 10 elements then order them alphabetically it's still the same 10 elements. I came across this as I'm creating a filtered list of elements to use for data validation. When finding a variance and exporting the details to a file it would have been nice if they were alphabetically ordered. As I mentioned you can do it in the subset editor easily (and I know you can do it with MDX) so why not have a command to do so?

The same 10 elements may well be the same 10 elements but the order those same 10 elements 10 different ways and you have 10 distinct subsets. That's just the way it is. Think about when you are using the subset editor or cube viewer, if you start from a named subset and do anything with that list of elements then you are no longer working with the previously defined subset, hence the subset name will disappear from the view properties or you will be prompted to save changes to the subset when exiting subset editor.

But if your're setting the subset order in the same tab within a TI is it really a different subset? I agree with what you're saying about the subset editor but it's not really relevant to what I'm suggesting with the command.

jim wood wrote:But if your're setting the subset order in the same tab within a TI is it really a different subset? I agree with what you're saying about the subset editor but it's not really relevant to what I'm suggesting with the command.

You're talking about a TI command to do the sort order when you're creating the subset, yes? I don't see the problem with that. I understand Lotsaram's point that if you change the order of a saved subset, it becomes a new subset but you seem to be talking about doing it as part of the creation process, which is quite a different animal. (Alternatively there is no reason why it couldn't be updated and resaved using this function, just as you can update most subsets in TI.)

I can see some uses for that too.

But given that we can't even get Iboglix to create the long-wished for and multiply-requested SubIx function[1], then I wouldn't hold my breath for this one if I were you unless you have a lung capacity which exceeds that of an Olympic swimming team.

--------------
[1] To return at least the first appearance of an element in a subset, lest the fact that an element can appear multiple times is raised. How many times, how many times and by how many people must this be requested before it is given some attention??