Is it possible to remove a specific child with the cubeset function. For example, if I have a limited number of children the function may look like this:

=cubeset("cnn","{[parent].[child1],[parent].[child2]}","Specific Children")
However, I have a much more complex dimension with around 50 children with respect to one particular parent. Literally, I want 49 of those children in the cubeset. So something to the effect of:

=cubeset("cnn","{[parent]-[parent].[child2]}","Specific Children")
Obviously, I could try to list each one, but Excel will not let me list that many, nor do I want to. While we are looking into revising the actual dimensionally within SSAS, that doesn't help me now.

Insight???

mjfii