HELP! Dimension Security
From: Chris H (chris_hotz_at__removethis_safetylogic.com)
Date: 07/07/03
- Next message: Adriano Galle Dal Prá: "permission"
- Previous message: Gran Goza: "stunnel (commercial alternative)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 7 Jul 2003 11:49:16 -0700
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
- Next message: Adriano Galle Dal Prá: "permission"
- Previous message: Gran Goza: "stunnel (commercial alternative)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
