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
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