Hello,

I need to restrict a dimension list based on the user.

Can this be done using cube/dim permissioning?
Is it necessary to place the user and the other dim attributes in the same
dim with the
user as the top attribute in the hierarchy?
Can I accomplish the same by making the user a member property of the other
attribute?

thanks in advance
Tarana

--
Message posted via http://www.sqlmonster.com

Hi Tarana

There are a number of ways you can do this. The method that I use is
dimension security.

You basically create a security cube and link it to your report cube via
virtual cubes

Two good articles on this subject can be found at

http://www.sqlmag.com/Articles/Index...rticleID=27040
http://www.sqlmag.com/Articles/Index...rticleID=27305

regards,

Tony
"tarana halsall via SQLMonster.com" <forum (AT) nospam (DOT) SQLMonster.com> wrote in
message news:7b23fdcada1742aa95bc1c3d318e1599 (AT) SQLMonster (DOT) com...