Hello!!

I am trying to implement dynamic security to my cubes but when i
implement whatever of the examples i have, it always returns an error
message!!!

Error:

Unable to process one or more commands.

User-generator error – dimension "myDimension" has no valid member.
For more information, see your administrator.

I had tried to implement another approach like member properties but
didn't work!! Same error.

I want to implement a Security Fact Table Approach.



Situation description:

I had created all the tables described in the presentation, and I had
create de security cube and the virtual cube.

When I test the role the error appears.

This is the filter i use to restrict mydimension:
STRTOSET(IIF(USERNAME="","{}",SETTOSTR(
NONEMPTYCROSSJOIN([DimensionA].[Dimension Name].MEMBERS,
{STRTOMEMBER("[Users].[User Name].&[" + USERNAME + "]")},1)
)))

What should I do??
Its a security problem?

Thanks in advanced…

André Fonseca

botinha (AT) netcabo (DOT) pt

Hi André,

The message you're getting means that your MDX is ok, but the expression is
returning an empty set - so there are no members on the dimension which this
user has access to. So, the first question to ask is, where are you getting
this message? If it is in Analysis Manager and you're using Test Role, then
does the user you are currently logged in as (which will be in the OLAP
Administrators group) have any permissions defined? If this user doesn't
have any permissions then you would expect the error you're seeing; try
logging in from a client as a user who you have defined some permissions for
and see if you get the same problem.

Regards,

Chris

--
Consultant, Microsoft Services Switzerland
(to email: remove 'online.' from the address this was posted with)

Microsoft Services Switzerland and our partners can help you with your
Analysis Services project!

Disclaimer: This posting is provided 'AS IS' with no warranties, and
confers no rights.

"Botinha" <botinha (AT) netcabo (DOT) pt> wrote