Select the product you need help with

FIX: Virtual Cube Returns Empty Cells if Custom Rule Is Applied

Article ID: 295706 - View products that this article applies to.

This article was previously published under Q295706

BUG #: 12147 (Plato7.x)

SYMPTOMS

A custom rule is used to control access to dimension members by users in a role. If you use a custom rule for dimension security in a virtual cube, the virtual cube may return empty cell values in the lower level of a dimension.

Back to the top | Give Feedback

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

(http://support.microsoft.com/kb/290211/EN-US/ )

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

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

MORE INFORMATION

Steps to Reproduce Behavior

Create a role named "TestRole".
On the Membership tab, add a user.
On the Dimensions tab, select the Store dimension, change the rule from Unrestricted to Custom, and then click the ellipsis (...) button on the Custom Settings column.
In the Custom Dimension Security: Store dialog box, select Deselect all members, expand All Store -> USA, select CA, and then click OK.
Create a virtual cube using the Sales cube.
Select Unit Sales for the virtual cube measure.
Use the >> button to select all dimensions, and then use the < button to clear everyone except Customer Pattern, Store, and Customers.
Save the virtual cube as Test1 and then process it.
Expand Test1, right-click Cube Roles and select Manage Roles.
Enable TestRole, and then click Test Role.
In the Cube Browser, drag the Store dimension to the data window, and expand All Store -> USA -> CA. Note that the values for the members "Alameda", "Beverly Hills", "Los Angeles", "San Diego", and "San Francisco" are all empty. Except for "Alameda", all members should have some values.

In step 7, if you use the > button to select the dimensions for the virtual cube, you do not see the described problem.

Back to the top | Give Feedback

Properties

Article ID: 295706 - Last Review: November 21, 2006 - Revision: 1.2

APPLIES TO

Microsoft SQL Server 2000 Analysis Services

kbbug kbfix kbssas800sp1fix KB295706

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top | Give Feedback