To synchronize the Member Selection dialog selections with the results of grid navigation such as Drilling and Keep/Remove Only, additional member selections are sometimes added to the Selected pane to reflect member selections that are excluded from the query. The exclusions appear when dynamic member selections are used (for example, Product (Children)).
To arrive at the proper member selection, exclusions are included in the MDX query to avoid having metadata queries executed. For example, a query has the following member selection in the rows: EntityABC (Member+Children), and the result includes the parent member and 10,000 children. When performing a Remove Only on one of the child members, instead of querying the 10,000 children to update the member selection dialog, an exclusion entry is created for the removed member. Additional examples are as follows, with exclusion entries in bold:
| Initial Query Selection | Query Operation | Resulting Member Selection |
|---|---|---|
| Year (Member+Children) | Remove Only: Qtr2 | Year (Member+Children) Qtr2 (-Member) |
| Year (Member+Children) | Keep Only: Qtr2 | Qtr2 (Member) |
| Market (Member - Descendants) | Drill Up: Florida | Market(Member +Descendants)East (- Descendants) East (Member) |