MDX: How to exclude ancestors from being returned in this query?

Posted by wgpubs on Stack Overflow See other posts from Stack Overflow or by wgpubs
Published on 2010-03-17T21:15:25Z Indexed on 2010/03/17 21:31 UTC
Read the original article Hit count: 278

Filed under:
|
|
|

I have this MDX query:

Exists([Group].[Group Hierarchy].allmembers,
    {[Group].[Group Full Name].&[121 - Group A], [Group].[Group Full Name].&[700000 - Group C]})

... which works fine EXCEPT that it returns all of the ancestors of the specified groups as well. What I want is to return JUST the groups from the hierarchy with the specified Group Names (this is a type 2 dimension so there may be many at different levels).

Any ideas?

© Stack Overflow or respective owner

Related posts about mdx

Related posts about sql-server