IN AS2K we can remove the ALL member. I'm looking at SSAS2K5 and I
can't find that anywhere to remove ALL member

It's quite simple - you need to mark the attribute as non-aggregatable -
this means that it doesn't aggregate up, and therefore the hierarchy where
it is first level won't have All level.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
<ricocali (AT) hotmail (DOT) com> wrote

Mosha,

Yes thats fine but what if I'm dealing with a parent-child dimension?

Same thing - define the parent attribute as non-aggregatable, and you won't
have All level in P/C hierarchy

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
<ricocali (AT) hotmail (DOT) com> wrote

Thanks Mosha...it works. I was confused because "IsAggregatible" was
only in context to the level.