In my current project, We are using SSAS 2005 and ProClarity tool for accessing cubes. We have setup security at dimensions level for each individual cubes.
Security Setting at SSAS Level
- 1. For Example: This security setup has been done to prevent users to not see other users’ data. Our Main dimension is DIM_PROVIDER and column Provider_ID and security setup has been done based on Provider_ID. Created a role ABC_Role based on requirement and for this role given specific access by editing role-->Go to ‘Dimension Data-->Under a cube (Regional Sales) you will have all dimensions used -->Select one dimension, for example, DIM_PROVIDER-->Go to Attribute Hierarchy and select column Provider_ID-->Deselect all members and then select only a specific member like 5 (ABC provider)-->Go to Advance Tab--> Check the ‘Enable Visual Total'-->This way you have to restrict all the dimensions where we have column Provider_ID -->Click ok
Now add those members (Group or users coming from Active Directory AD) to ABC_Role who all belongs to Provider ABC
Security Setting at ProClarity Level
- 1. Go to Analytic Server Administration Tool-->Click on Roles-->Add the Members to ABC_Role who all belongs to Provider ABC.
So this way when a user try to access ProClarity URL, user needs to provide User ID and Password and based on role user will be able to access data only related to him/her. User can build own report (ProClarity View) and can save it.
We have plan for using Qlikview instead SSAS and ProClarity and same security setup needs to be done in Qlikview. Is this possible? If yes could you explain or provide documents or link
