Role definition for user access

• rpetton 60072

  SSC Journeyman

  Points: 76

  More actions

  November 7, 2016 at 4:30 am

  #315395

  Hi everybody,

  I don't understand the concept of cube security (SSAS 2012) and may be someone can help me out.

  Here my problem:

  I do have a cube where the sales-data for the whole company is in.

  Each sales person should have access to the cube and is allowed to see only his own customers.

  Each customer has about 20 attributes.

  Now I do understand the concept to secure one attribute with a NonEmpty-statement and the username-function connection both (Dimension and username) with a bridging-table.

  Now my question:

  Do I have to secure every single attribute or is there a way to tell the system that when I secured the key-attribute that all the other attributes are secured automatically (for example with a scope-statement)?

  That means: Is there an easy way to slice the dice by a user-login?

  Thanks for help

  Rene