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
Now add those members to ABC_Role who all belongs to Provider ABC
Security Setting at ProClarity Level
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.
Now I got requirement to test that above security setup for QlikView which will point to existing cubes or Is it possible to set same security as cube to QVD and QVW so that QlikView can directly point to Database instead of Cubes? Could you please guide me. If possible provide me the links those can help me.