MDX Query
I'm trying to create an MDX query to do the following.
I have
Group A which contains Group 1 (ALL_BU)
Group A also contains Group 2 (Chartwell 2011) - Group 2 consists of an alternate hierarchy with some of the elements in Group 1 as shared members, but is a separate tree from Group 1.
Groups 1 and 2 are on separate tree's so they are exclusive of each-other, but the level 0 elements in Group 2 are all contained in Group 1. Both groups have a ragged tree structure. I need to remove the list of level 0 elements from Group 2, and return the larger list from Group 1. This seems basically impossible because the syntax doesn't seem to eliminate the items that are not part of a subset of the larger group.
I have
Group A which contains Group 1 (ALL_BU)
Group A also contains Group 2 (Chartwell 2011) - Group 2 consists of an alternate hierarchy with some of the elements in Group 1 as shared members, but is a separate tree from Group 1.
Groups 1 and 2 are on separate tree's so they are exclusive of each-other, but the level 0 elements in Group 2 are all contained in Group 1. Both groups have a ragged tree structure. I need to remove the list of level 0 elements from Group 2, and return the larger list from Group 1. This seems basically impossible because the syntax doesn't seem to eliminate the items that are not part of a subset of the larger group.
0