Removing Child w/ Cubeset:

**mjfii** · 08-18-2010, 02:23 PM

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

**martindwilson** · 08-18-2010, 02:38 PM

where is the formula "cubeset" coming from ?

**mjfii** · 08-18-2010, 03:20 PM

Cubeset, CubeMember, CubeValue are out of the box functionalities of Excel 2007 to drill into analytical OLAP cubes...

**martindwilson** · 08-18-2010, 04:48 PM

well i never! now I've learnt another thing ! hmmmm best i look at my 2007 a bit more deeply. so that is an indication that I have no idea what it does or what it's for.
sorry.