MS SQL Data Warehousing - MDX Filtering help!!

Author

MDX Filtering help!!

Luis.Andrei.Cobo

2006-01-23, 9:23 am

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

2006-01-24, 7:23 am

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@g43g2000cwa.googlegroups.com>,
luis.andrei.cobo@gmail.com says...
> 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
>
>

Sponsored Links