Insert component in subset

Post Reply
pmakulski
Posts: 60
Joined: Mon Jun 06, 2011 6:07 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Insert component in subset

Post by pmakulski »

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.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Insert component in subset

Post by jim wood »

There was a post about this a week or so ago. Have completed a search?
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Insert component in subset

Post by jim wood »

Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply