PRB: User in Two Roles May Cause Query Execution Failure (328573)
The information in this article 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 "CubeName" does not exist, or it is not processed
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 "Custom Setting" role with different top and bottom levels, make it's "Custom Setting" 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.
| Modification Type: | Major | Last Reviewed: | 6/25/2004 |
|---|
| Keywords: | kbprb KB328573 kbAudDeveloper |
|---|
|