Thanks, but yes we've perspectives in the Cube. But if you want to do more detailed analyses you may want to omit the cube and access the DB layer directly. What I'm thinking about is a view solution in a semantic layer where the data can be accessible.
However, I'm not yet quite sure of the setup of such a solution.
The users will be connected to different AD (Active Directory) groups and the AD-groups can be connected to DB roles?