Data Permissions in a cube
Posted on 2007-11-19
I have a database with customer subscription data in it. CusA and CusB. I have built a cube for it and currently have it set up for internal staff to use, so they can see everything.
Could someone point me in the direction of how to restrict the data in the cube so each customer can only see their own data. i.e.
If they log into the cube using Admin, all of the subsctiptions fact table is used. If they log in using CusA only data where owner = CusA is displayed. If they log in using CusB only data where owner = CusB is displayed.
Any help would be much appreciated. I'm currently trying to find out using MDSNs website, SQL Server 2005 Analysis Services Step by Step (isbn 0-7356-2199-3) and Delivering Business Intelligence with Microsoft SQL server 2005 (isbn 0-07-226090-4), but I cant seem to work out how to apply their examples to my project and i've managed to read the information differently so it conflicts, i.e. should i be setting the permissions in the DB so the cube inherits it or set up the permissions in the cube. Any help would be much appreciated as i'm very stuck! Thanks.