| wall.andrew@gmail.com 2006-03-15, 8:24 pm |
| I am in need of some help in trying to tie down security in an Analysis
Services 2005 cube. I have a number of dimensions and few measures and
the cube is queried by a web client by the users.
One of the dimensions is say dimA. What I need is to be able to only
return records relating to memberX in dimA even if that dimension is
not included in the current query. I have read much information
relating to dimension security but as I understand it, if I tie a role
to only look at that member, it only works when the dimension is
included in the query. Thus if the user does not use that dimension in
a query, all records will be returned in the resultset.
Previously I have created seperate cubes for each scenarion which is
fine if there is only a handful, but not if there are more than 10!
Hope someone can point me in the right direction.
AW
|