Microsoft KB Archive/328573

= PRB: User in Two Roles May Cause Query Execution Failure =

Article ID: 328573

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q328573



SYMPTOMS
Query execution fails if the following conditions are true for a user connection to Analysis Services:
 * The user is in two different roles.
 * Both roles have non-default security settings on the same dimension, but with a different Top Level or Bottom Level.

You may receive these errors when you execute an MDX query, or when you browse a dimension from a MDX Sample program:

Unable to open cellset The cube &quot;CubeName&quot; does not exist, or it is not processed

-and-

Unable to open cellset Connection to the server is lost



CAUSE
This feature is not supported by Microsoft Analysis Service 2000.



RESOLUTION
If you have to put one user into different roles but against the same dimension, make sure that those roles have the same Top Level and Bottom Level.

Keep in mind that if the rule of a role is Fully Restricted, the Top Level and Bottom Bevel are both the All Level. For it to work with another &quot;Custom Setting&quot; role with different top and bottom levels, make it's &quot;Custom Setting&quot; match the Top and Bottom levels, and use the following advanced settings:

Allowed Members:

{[Dimension Name].[All Level Dimension Member]}

Denied Members:

{[All Level Dimension Member].Children}

These settings yield the same result as Fully Restricted; only the All Level Dimension Member can be accessed.

Additional query words: olap permission

Keywords: kbprb KB328573

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.