MS SQL Server OLAP - Validate Role

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Validate Role

Sandro

2005-04-25, 7:23 am

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

Sponsored Links