Re: SSAS 2005: Base role security on a perspective

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

not possible

perspectives are not deisgned to help the security management.
If a user access 1 cube, then the user can access all perspectives too. You
can't restrict the perspectives available by user.

everybody ask to have a security like you describe (limiting access by
perspective) but today its not possible.

you can use the linked feature to create a new cube and link it to the first
one and restrict what you link or not.


"Bjoern Hennig" <BjoernHennig@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0F32D27C-8532-4F1D-A25E-6DC015344A04@xxxxxxxxxxxxxxxx
Hi,
in one of our cubes we are making extensive use of perspectives.
What I would like do, is to limit the measures and dimension of certain
user
groups to a corresponding perspective.
Obviously I can create a role for each user group and select the relevant
measures dimensions to be accessable for that role.
However it would be much more convienient to allow a role only to access a
certain perspective. I am pretty sure I read that this is possible but I
don't seem to find a way to set this up.

Thanks

Bjoern





.

Relevant Pages

  • Re: SSAS 2005 Role Level Security for Calculated Members and Sets
    ... I have several roles created in the cube, ... dimensions and hierarchies and then several ... it will meet your needs for average metrics so you can avoid the ... Perspectives are easy to set up and provide a great ...
    (microsoft.public.sqlserver.olap)
  • Re: Is the UDM a super cube?
    ... A perspective is like a view on a cube - it allows you to make certain ... measures, attributes, dimensions etc invisible to reduce the complexity of ... Perspectives are not a form of security though. ... A data source view is a way of filtering down the number of tables and views ...
    (microsoft.public.sqlserver.olap)
  • Re: The end of the input was reached. error after I process 1 cube
    ... I have deleted ALL the perspectives and recreate them and the problem is ... I have try deleting 1 at a time in different order, but this doesn't works, ... I process 1 perticular cube. ... does the translations can cause this issue? ...
    (microsoft.public.sqlserver.olap)
  • Re: 2005 / virtual cubes
    ... And a perspective is far from the same as a Virtual Cube as your only option ... securable:/ And you have to use the Enterprise Edition to use perspectives. ... you can process the data only, and aggregate later (the aggregation step ...
    (microsoft.public.sqlserver.olap)