Microsoft KB Archive/295683

= FIX: Virtual Cube Returns #ERR if You Use Dimension Security and Visual Total Together =

Article ID: 295683

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q295683



BUG #: 12012 (Plato7.x)



SYMPTOMS
In a database role or cube role, by defining a custom rule for a dimension, you can specify which dimension members can be accessed by end users in the role. If you also specify options for visual totals with Dimension Security in a virtual cube, the virtual cube either returns #ERR or incorrect values.



RESOLUTION
To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.



Steps to Reproduce Behavior

 * 1) Open Analysis Manager, and then select the Foodmart 2000 database.
 * 2) Expand the Sales and Warehouse cube (virtual cube).
 * 3) Right-click Cube Role, and then click Manage Role.
 * 4) Click New to create a new cube role.
 * 5) Name the new role TestRole.
 * 6) Under the Membership tab, add a user login account.
 * 7) Click the Dimension tab, and then click Dimension name Education Level.
 * 8) Click Custom at the Rule column for Education Level.
 * 9) Click the ellipses (...) in the Custom Settings column.
 * 10) In the Custom Dimension Security: Education Level dialog box, expand All Education Level under Members: field.
 * 11) Clear the members Graduate Degree, High School Degree, Partial College, and Partial High School check boxes.
 * 12) Click Common.
 * 13) Click Enable - Show Visual Totals.
 * 14) Click OK until you return to the Cube Role Manager - Warehouse and Sales dialog form.
 * 15) Click Test Role.
 * 16) Scroll the horizontal scroll bar or maximize the Cube Browser window to see the problem described in the &quot;Symptoms&quot; section.
 * 17) Close the Cube Browser, and then close the Cube Role Manager.

The following error message displays:

&quot;Could not unlock object (Warehouse and Sales)

Connection to the server is lost

You need to restart Analysis Manager.&quot;

Additional query words: permission invalid undesired OLAP

Keywords: kbbug kbfix kbssas800sp1fix KB295683

-

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

© Microsoft Corporation. All rights reserved.