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

Maybe you need the "Visual Totals" option?

http://www.sqlserveranalysisservices...ices2 005.htm
....
Visual Totals

If a member of an attribute hierarchy is secured, one has two choices to how
data rolls up to the all member of the hierarchy:

- users see the true totals

- users see the totals of the data they are permitted to see.
....

"wall.andrew (AT) gmail (DOT) com" wrote:

Should have added that I am in SQL2000 (currently).

Should have added that I am in SQL2000 (currently).

In article <1142545689.133104.260460 (AT) e56g2000cwe (DOT) googlegroups.com>,
Richard.Flewitt (AT) asb (DOT) co.nz says...

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell