Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to setup Roles Dimension Data Expand / Collapse
Posted Friday, August 17, 2012 12:33 AM


Group: General Forum Members
Last Login: Friday, January 23, 2015 1:22 AM
Points: 13, Visits: 51
Hi, I'm looking at a SSAS Cube (version 2008) where I have made a role that has limited access to dimension. User in this role only gets a choose of 3 countries. But the problem is that I would like this limitation to be more general. For example if user chose All I would like that to mean just these 3 countries but now users get all data. And if the dimension is not used at all then no limitation is done.
So, how can I setup a more general filter that always will filter out these values?
Post #1346348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse