Subset changes order when expanding and collapsing

[mmckimson]

I have a weird problem that I thought I'd see if anyone has a solution. I have built a static subset for an income statement, and to make it look like most people expect have set parents to "expand above". In the actual dimension structure, when the dimension members are viewed in a hierarchy (the basis for our subset), the parent / child I'm having an issue with looks like this:

PARENT
--Item 5 (Index 5)
--Item 6 (Index 6)
--Item 1 (Index 1)
--Item 2 (Index 2)
--Item 3 (Index 3)
--Item 4 (Index 4)

The reason the items appear in the hierarchy this way, is that Items 1 - 4 were originally a part of a consolidation falling under PARENT that has been eliminated. When I created my subset, I turned on the "expand above" option, and went about my business of making the subset look as follows:

--Item 1 (Index 1)
--Item 2 (Index 2)
--Item 3 (Index 3)
--Item 4 (Index 4)
--Item 5 (Index 5)
--Item 6 (Index 6)
PARENT

The subset is of course used in a view, so the subset is also set to show all elements so it looks how a typical end user would expect to see an income statement.

The issue:

When the subset is initially viewed, it appears exactly as I set up the order in the subset. However, as soon as a end user collapses the parent and then later re-expands the parent, the elements of the parent now appear as in the dimension structure and not in the structure as built in the subset (albeit with the parent still being shown on the bottom of the hierarchy as designed).

I don't really understand why it would do this. Any suggestions on how to modify the behavior I'm seeing?

Thanks,
Mike

[tomok]

I don't really understand why it would do this. Any suggestions on how to modify the behavior I'm seeing?

I think you are expecting TM1 to be more than it is. Subsets are quite primitive. All you can do is create them statically, or as an MDX query, and choose whether to show the elements themselves, or an alias. You can't control the expand and collapse behavior of any of the elements in the subset.

[lotsaram]

I don't really understand why it would do this. Any suggestions on how to modify the behavior I'm seeing?

I think you are expecting TM1 to be more than it is. Subsets are quite primitive. All you can do is create them statically, or as an MDX query, and choose whether to show the elements themselves, or an alias. You can't control the expand and collapse behavior of any of the elements in the subset.

Or in other words what you are seeing is normal and expected behavior.

[jstrygner]

Just found this post.

If you want this:

PARENT
--Item 5 (Index 5)
--Item 6 (Index 6)
--Item 1 (Index 1)
--Item 2 (Index 2)
--Item 3 (Index 3)
--Item 4 (Index 4)

To become (after collapse/expand) like this:

PARENT
--Item 1 (Index 1)
--Item 2 (Index 2)
--Item 3 (Index 3)
--Item 4 (Index 4)
--Item 5 (Index 5)
--Item 6 (Index 6)

You can e.g.:

• Open your dimension for edition (Dimension Editor).
  Collapse and expand the PARENT consolidation to see the initial order of elements under it.
  Select the first two children elements (Item 5 and Item 6).
  Using drag and drop "re-attach" them under the PARENT element.

It will work like you would remove them from the parent and then again pin them as children, so their "child" order will get re-set and the newest children will move to the end.

If you use xdi to define dimension structure this is even more obvious. You can exactly define the order of children under each consolidation.

Old post, but still... HTH