In the time dimension, we have following levels:
Year, Quarter, Month and Day.

I defined some named sets including Day level member, and derived some
calculated members based on the named set in a virtual cube.

Then I define a dimension security on Time to allow top level to All Time,
bottom level to Month. After that the users belong to the security role can
not see the calculated members defined in the virtual cube. Why?

The obvious explaination is the day level is not accessable in the virtual,
but the dimension security should only affect visibility not accessibility,
right?

How do I fix the problem? Thanks

Hi Yongli:

it affects both of them
--
Alejandro Leguizamo
MVP SQL Server
Colombia

"yongli" <yongli (AT) discussions (DOT) microsoft.com> wrote