BUG: You receive an error message when you try to deny access to a dimension member for a cube role by using a custom rule in Analysis Manager (843026)


The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services
Bug #: 14333 (Plato 7x)
Plato 7x:14333

SYMPTOMS

When you try to deny access to a dimension member by defining a custom rule in a cube role in Microsoft SQL Server 2000 Analysis Services, you may receive an error message that is similar to the following:
Dimension security syntax error:
Set name xxxxx.xx is not valid.
Do you still want to use this expression for dimension security?
If you click Yes in the error message, the Custom Dimension Security dialog box closes. However, the cube role may be updated correctly, and access to the dimension member for the cube role will be denied. If you click No in the error message, you return to the Custom Dimension Security dialog box.

Note You can verify whether access to the dimension member is successfully denied to the cube role. To do this, click Test Role in the Cube Role Manager dialog box.

WORKAROUND

To work around this problem, delete and then re-create the dimension security for the dimension.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Steps to reproduce the problem

  1. Start Analysis Manager.
  2. In the left pane, expand your Analysis server computer, and then expand FoodMart 2000.
  3. Expand Cubes, right-click Sales, and then click Manage Roles.
  4. In the Cube Role Manager - Sales dialog box, click the All Users role under the Roles column header.
  5. Under the Restricted Dimensions column header, click the ellipsis button (...).
  6. In the Edit a Cube Role dialog box, click the Dimensions tab.
  7. Under the Dimensions column header, click the Customers dimension.
  8. Under the Rule column header, click the Custom rule.
  9. Under the Custom Settings column header, click the ellipsis button (...).
  10. In the Custom Dimension Security: Customers dialog box, click the Basic tab.
  11. Under the Select members box, click Deselect all members.
  12. In the Members box, expand All Customers, expand USA, and then expand CA.
  13. Under CA, click to select the Altadena check box, and then expand Altadena.
  14. Under Altadena, click to clear the Alice Cantrell check box, and then click OK.
  15. Repeat step 9 to step 13.
  16. Under Altadena, click to select the Alice Cantrell check box, and then click OK.
  17. Repeat step 9 to step 13.
  18. Under Altadena, click to clear the Alice Cantrell check box, and then click OK.

    You may receive the error message that is mentioned in the "Symptoms" section.
Note You may not receive the error message that is mentioned in the "Symptoms" section the first time that you reproduce the problem. In this situation, you must repeat step 15 to step 18 many times to receive the error message.
Modification Type:MajorLast Reviewed:7/19/2004
Keywords:kberrmsg kbbug KB843026 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.