Hi,
i am using Analysis Services 2005.

I have a dimension called dim_users. Now i want to filter this table
depending on the current logged in user.

To lookup which user is allowed to see which user, i created a table on
the SQL Server, looking like the following:

UserLogin | AllowedUserID

UserLogin is the current user (the user running the query against the
OLAP Server). AllowedUserID contains the User on which UserLogin should
have access to.

For example:
A | A
A | B
A | C
A | D
A | E
B | B
C | C
D | D
E | E

This means, User A should be able to see all data. User E is only able
to see his own data.

How can i use this table to filter this dimension using the role? How
should the MDX query look like?


Thx in advance,
Patrick Dinger