locked
needed information about the roles of access for a cube RRS feed

  • Question

  • we have a cube (regarding insurance), which is accessed by users by an excel sheet? now they want to restrict the grand total view by the users depending on the user id, i.e there are AccountExecutives each AccountExecutive must be allowed to view only commision related to them. How can it be achieved? and where can I get the information related to the roles and the permissions to access dimensions and restricting access to data depending on user id s? (kindly provide as much detail as you can, because I am new to ssas)

    Friday, September 17, 2010 10:50 AM

Answers

  • Hi,

    If you want to create roles for each user, just use the check the checkbox ‘Enable Visual Totals’ in Dimension data tab. For example:

    UserID    Value

    A            10

    B             20

    Total          30

    The user A will see below results with checkbox ‘Enable Visual Totals’:

    UserID    Value

    A            10

    Total          10

     

    However, if you want to create one role for those users, then you can try the dynamic dimension security:

    http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/5156c23b-f984-4453-af8f-605ff3f17fe1

     

    Hope this helps,

    Raymond
    Raymond Li - MSFT
    • Marked as answer by Raymond-Lee Sunday, September 26, 2010 3:56 AM
    Monday, September 20, 2010 11:13 AM

All replies