TM1 Forum

I'm trying to figure out this MDX dynamic subset. Really cool; I like the "record" feature.

One thing I can't figure out how to do ...

I have a rigid hierachy supplied from an external source (the G/L).
It's hierarchy looks like this:
Parent
[]Child 1 ... Child 10

I'd like to add two subgroups to parent, so my subset looks like this:
Parent
[]Group 1
[] [] Child 1, 6, 8
[] Group 2
[][] Child 2, 3, 4 etc.

Is this possible

I can't seem to add Group 1 and Group 2, on the fly using MDX.
And if I add Group 1 and Group 2 to the dimension as children of Parent, I can't get Child n to move, on the fly, to the Groups using MDX.

There was a post about this a week or so ago. Have completed a search?

Try this....http://www.tm1forum.com/viewtopic.php?f=3&t=205&start=0