HELP! Dimension Security

#1

I checked :-( I do have records for those who are
failing. I even compared the fact records for a user at
the same level who works... the records are identical
except the account key (which should be different...)
ch

Quote:

-----Original Message-----
The reason for some users are getting error is that, with
teh secuirty rule applied on teh virtual cube, these
users
do not have a valid members in the
dimension "Institution".

Can you check the secuirty cube/fact table and see
whether
you have got records for users for whom you are getting
this error.

-----Original Message-----
I'm very new to AS/MDX and am having some problems with
this filter, which I found in the SQL Server Mag January
issue. This filter is applied to the institution
dimension
in my virtual cube and is defined in the Allowed members
area under the advanced tab under custom dimension
security.
Filter( [Institution].[Name].Members,(STRTOTUPLE("[" +
TRIM
(MID(USERNAME, INSTR(1,USERNAME,"\") + 1, 128)) + "]"),
[Measures].[SFAccess]) = 1)

My setup is this. I have a virtual cube that points to
two
standard cubes one is a "data" cube and the other is a
Security cube with a fact table and two dimensions.

My problem is that the filter on my role works for some
users (NT Accounts) and not others. I have not been
able
to draw a correlation between any of the users that work
and those that don't. Here is the error message I get:
User-generated error - the dimension "Institution" has
no
valid member. For more information, see your
administrator.

I've tested users that exist at the same hierarchy level
in the institution and have the same permissions
(regarding what members they can see), some work and
some
don't? I'm quite puzzled and cannot think of anything
else to try. :-0 . Has anyone heard of a bug that might
pertain to this?
Thank you!
Chris Hotz
chris_hotz at safetylogicDotcom

.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

HELP! Dimension Security

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

HELP! Dimension Security - 07-07-2003 , 02:21 PM