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

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.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1138028901.138841.192750 (AT) g43g2000cwa (DOT) googlegroups.com>,
luis.andrei.cobo (AT) gmail (DOT) com says...