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

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

MORE INFORMATION

Steps to Reproduce Behavior

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

The following error message displays:

"Could not unlock object (Warehouse and Sales)
Connection to the server is lost
You need to restart Analysis Manager."