HomeSecurityShow correct totals when using SSAS role security

Comments

Show correct totals when using SSAS role security — 16 Comments

  1. Hey James, I’m using Roles in SSAS and I want a specific Role to see the Visual Totals for a particular Measure as exactly as you described in this article. I went to the 1.) Dimension Data tab of the specific Role, 2.) clicked on the Advanced tab, 3.) selected the Measures Dimension and the desired Dimension I want the totals to update, and 4.) clicked the “Enable Visual Totals” checkbox. This still proved unsuccessful for me. After processing my Cube, I Browsed the Cube using the Role I just modified and the Totals still aren’t updating as expected. Any other suggestions? Thanks!

  2. Hey James, sorry for the late reply but I’ve lost touch with this for a bit. Are you saying only “Enable Visual Totals” on the Cube Dimension only and not the Database Dimension? Thanks!

  3. Hi James,

    I have exactly the same problem as Joey Babu. In a certain dimension (business unit) I select the members that are relevant to the role. Then I expect to see only the numbers for the selected dimension members. It works when I browse the cube using Management Studio but when I use Excel 2010 the total includes the numbers related to all members. BTW: I am using a dimension that is not role-playing and I tried both scenarios on database (shared dims) and cube level.

    Any comments would be appreciated.
    Thanks,
    Maikel

  4. Hi James,

    Forget about my last post. The user I was testing with was member of another role (admin). Everything works just fine.

    Maikel

  5. Hi James,
    Thanks for this great post. My problem is a bit different than what you are discussing here, may be if you can suggest anything to me. In the example give above what if I want a user of Division A should be able to see correct totals but when he drill down he should be able to view revenues of only his division, in this case Division A.

    We have a scenario where we are generating a Accounting Cube, which will be accessed by different department people. My client wants to show correct Net profit to every user, but when it comes to base accounts by drilling down the net profit hierarchy he only wants users to see Accounts for which they have access, I wanted to know if there is any feature in SSAS I can use for this.

  6. James brother… that is just wonderful.I can’t thank you enough for this post. There was a critical issue that came up this morning and my boss referred me to your website 🙂 It is amazing how this simple little check box can create miracles when it comes to confidential information and data privacy.

    Have a great day and thanks much again!

  7. Pingback:Preparation for the 70-467 SQL BI exam | x86x64

  8. Pingback:How to optimize the dimension security performance using partitioning in SSAS Multidimensional – My Blog

  9. Pingback:Cómo optimizar el rendimiento de la seguridad de la dimensión mediante el particionamiento en SSAS multidimensional – My Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>