Does it by any chance happen on the virtual cube ?
--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Sandro" <Sandro (AT) discussions (DOT) microsoft.com> wrote
Quote:
I have a cube with 1 role with more than 200 membership defined. People
belonging to this role can view data and those not cannot view the data.
Each
night the Analysis Service is restarted. Each morning Users who belong to
this access
role cannot access the cube. When I re-validate the database role, then
users belonging to the access role can view cube data. Anybody have a
solution to solve this problem definitively, without this workaround ?
thanks in advance |