Members selection in SSAS can be based on an "And" logical operation. The "Existing" MDX function fails if the filter selection is placed in the sub-select/sub-cube.  The BI Portal offers a solution.

The BI Portal offers a complete security solution. It supports all security models offered by SSRS, SSAS, and SQL.  It also allows the user to login once and his/her identity to flow to the Web App, SSRS, SSAS, and SQL services.  This makes it possible for a non-technical user to perform Self-Service BI.

This platform also allows with a SINGLE Report and Datasource, unlimited number of users with unique security requirements to be served with customized data and reports.