OLAP & secure data

W

Willy_comp

Is it possible to build a OLAP cube and then limit the access per project
leader according to the security as defined in the category & group he
belongs to ?

Our project leaders are limited to see additional projects where they are a
team member (and of course those they manage). RBS-based selection is not
activated.

When they open a OLAP-view, they can see all the data of all the projects.
Can thus limit their selection/drill down options ?

regards
Willy
 
D

Dale Howard [MVP]

Willy --

Portfolio Analyzer views are meant to display project and resource data
across all of the projects in the portfolio. You can create a View that
displays only certain projects and certain resources, but anyone who can see
the View can also select all projects and all resources if they wish.
Sorry.
 
H

Hasaj Patrik

I think that there is possibility to set up access rights on the OLAP server
+ OLAP cubes. When you have created dimension Project Owner, you can set up
permissions(filters) for each value of project Owner using Windows
Authentication.

What is wrong, zou have to to it for each owner, resp. user or users group.

patrik
 
Top