What is the effect of removing an expansion on the results?

• A. Reverse order
• B. Exclude some members
• C. Replace some members
• D. Strike through some members

Answer: (B)

Removing an expansion means you retract the added members that were shown when the dimension was expanded. Expanding a dimension brings in more members; when you remove that expansion, you go back to the original, smaller set, so some members are no longer included in the results. It doesn’t reorder, replace, or strike through items—just narrows the view to the base level, effectively excluding the expanded members. For example, expanding a geography dimension might show country, state, and city; removing the expansion returns to the base level and excludes the detailed sub-members like states and cities.