Hi everyone,

I have some problems define roles in Analysis Services.

My dimensions are:
Projects
Employees

The measure is:
Hours

I want that the user can see only the projects asigned to him, and the
employees that have hours in that projects. The user must not see the hours
of employees in other projects.

I have define the next Custom Dimension Security:

- Dimension Projects:
Allowed members:
{[Projects].[Projects].&[201149]}
(201149 is the allowed project for the user)

- Dimension Employees:
Allowed members:
NONEMPTYCROSSJOIN([Employees].[Employees].MEMBERS,[Projects].[Projects].memb
ers,1)

I have tested it in "Test Role" option, but if I don't select the project I
can see all the employees hours and I can select any employee.

I have spent a lot of time try to understand this without any result... I
really appreciate some clue...

Thanks!