We can filter the OLAP data based on excluded members in
pivot components. This feature provides you an option to filter members based
on include or exclude members.
Example Scenario: You can filter countries (Australia,
Canada, US, UK) based on included members (Australia, UK). The result populated
as Australia and UK.