Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 31, 2014 9:30 AM
Points: 13, Visits: 50
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