You can try with any other cube of your database.

Ramunas

Steve,

this is the former.

The partialy solution is to create 2 roles with appropriate permissions. I need 2 applications with 2 connection string with ROLE keyword specified in the...

But when I add my user to these 2 roles, this user can see all data, because he can view union of 2 roles.

As I said, I need that one...

As I undrestand, you offer to restict access to a particular dimension. But when I set do it, user cannot see the dimension absolutely.

I have situation like this:

user...

Yaaa, that worked! 

Thanks, Steve

Ramunas Balukonis

This is valid connection string, and query logging works correctly before I stop sql sever service.