Security Arrangements for Proclarity Dashboard vs Proclarity Desktop RRS feed

  • Question

  • I'm wondering how we might implement a security scheme across several Proclarity products.  We have a SSAS database with 2 cubes in it.  Cube 1 has sensitive data in it while Cube 2 does not.  We have 2 types of users.  User group 1 should have full access to Cube 1, while User group 2 should not.  For Cube 2, both user group 1 and user group 2 have full access.  Both User group 1 and 2 have Proclarity Desktop Professional.

    However, we would like to be able to create dashboards in Proclarity Dashboard Server that have views that point to Cube 1 that both User group 1 and 2 can view.  Is there a way to accomplish this which still prevent User group 2 from being able to access Cube 1 from Proclarity Desktop Professional?

    I'm not an IT pro, but would think that there has to be a way to firewall User group 2 from navigating Cube #1 freely in PDP (or even seeing it at all) while allowing for them to view dashboard pages.

    Thanks in advance for your help.

    Friday, September 11, 2009 7:42 PM

All replies

  • Hello,

    First, make sure you secure all your data on the back end in SSAS.  Use Windows groups and SSAS roles to properly secure the data.  ProClarity products, out of the box, use Windows security to access SSAS data and will not show data that the user does not have role access to. 

    You will want to configure your roles in SSAS to reflect the needs of user group 1 and 2.  ProClarity Pro will automatically use the currently logged on Windows user to access SSAS. 

    Regardless of which ProClarity product you use - Pro, Dashboard, Web Standard, security on the data is respected.  There are objects in ProClarity that can be secured in ProClarity products - such as Libraries, Books and objects in the Dashboard.  However, this is not data security and you need to start at SSAS.  This might give you some ideas:  http://www.bing.com/search?q=role+security+ssas&src=IE-SearchBox&FORM=IE8SRC.  Please let us know if you have further questions.

    Monday, September 14, 2009 9:36 PM