SQL Server Performance

Cube roles don't work properly - bug in Analysis ?

Discussion in 'Analysis Services/Data Warehousing' started by otto-mueller, Dec 13, 2005.

  1. otto-mueller New Member

    Hello All,<br /><br />I have the following problem. I believe it is a bug on the MS-Analysis Services side, but don't know, how to solve it.<br /><br />My System:<br />- MS Windows 2003 Server<br />- MS SQL-Server 2000 Enterprise (SP4)<br />- MS Analysis Services 2000 Enterprise (SP4)<br /><br />Problem:<br /><br />Ther are several roles defined for a Cube, like Admins, Users etc. Sometimes get the users who are defined in the Users-Role a warn-message. It says like: You can not access this Cube because you do not have any permissions on this Cube.<br /><br />After displaying this message, I have checked the Users-Role for this Cube. Its check-box is active - it means Users-Role should actualy have fully permissions. But it is not so [<img src='/community/emoticons/emotion-6.gif' alt=':(' />!]- If you click on "Test Role", it returns the same warn-message as mentioned.<br /><br />A temporary solution is to deactivate and activate the Users-Role manualy, then it works for a time.<br /><br />Does anybody have an experience like this and what is the reason/solution for that?<br /><br />Thanks alot in advance<br /><br />greating<br />Otto
  2. ranjitjain New Member

    Hi,
    Check this link, you will find many good articles on managing roles in cubes.
    http://www.exforsys.com/content/view/1410/332/

Share This Page