Hi Akshai / Deepak / Mosha ,

I am currently setting up Dynamic security using the Filter in the
Allowed Members for User. I want to restrict the user (who is currently
logged and i can get his user name as username) to be only able to see
the memebrs which are below his/her HIERARCHY.

The MDXes are :
-----------------------------------------------------
Allowed Members :
{
Filter([Sales Representative].[DFM].Members, [Sales
Representative].CurrentMember.Properties("login name") =
userName)
}

-----------------------------------------------------
Denied Members :
Except({Ascendants([Sales
Representative].[DFM].Members.item(0))},{[Sales Representative].[All
Sales Representative]} )

====================================
If i define only the Allowed MDX (i didn't defined any MDX for Denied
Members), the parent members of the current hierarchy are shown, but i
dont want to see the parent members, just directly browse to the member
which is allowed.

Not sure which version of Analysis Services you're using - with AS 2000,
you could define the Top Level for custom rules as [Sales
Representative].[DFM]:

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agsecurity_2b95.asp

For each dimension you can specify a range of dimension levels that can
be accessed by selecting one or both of the following:

Top level

Indicates the topmost level that can be accessed. Levels above the top
level cannot be accessed. By default, top level is the dimension's
highest level.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***