Heres my scenario:
I have a dimension which has levels. For example, I have this:
7ZZZZ
70ZZZ
71ZZZ
72ZZZ
73ZZZ
And I need to make a calculated cell which will zero out all the
decendants of 7ZZZZ EXCEPT for 73ZZZ, using the calculated cell
builder. There doesn't seem to be, at least from my looking at it, a
function to exclude a particular descendant based on criteria other
than duplicates or matching items. Short of creating a calculated cell
for each descendant, except the one I don't want to include, is there a
quick way to do this in one calculated cell? I was looking at EXCEPT,
and DESCENDANTS and named sets even, but nothing seemed to work
properly for what I needed this to do.
Let me know
Thanks!!
Luis Andrei Cobo
<Darren Gosbell - 24 Jan 2006 11:47 GMT
Look up "Unary Operators" in Books OnLine. These will let you control
how individual children rollup to their parent, based on a column in
your dimension table.

Signature
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
> Heres my scenario:
>
[quoted text clipped - 20 lines]
>
> Luis Andrei Cobo