FIX: MDX Queries Return "#Err" as the Result Set When You Enable "Visual Totals" on Private Parent-Child Dimension (810440)

MORE INFORMATION

Steps to Reproduce the Problem

1. In Analysis Manager, in the FoodMart 2000 database, expand the Cubes folder.
2. Right-click the Budget cube, and then click Edit to start Cube Editor.
3. Right-click the Account shared dimension, and then click Remove to delete the dimension.
4. Right-click Dimensions, and then click New Dimension.
5. Click Next in the Welcome to the Dimension Wizard.
6. In the Dimension Wizard, follow these steps:
   1. In the Choose how you want to create the dimension page, click Parent-Child: Two related columns in a single dimension table, and then click Next.
   2. In the Select the Dimension table page, click the Account table in Default Schema, and then click Next.
   3. In the Select the columns that define the parent-child data hierarchy page, set the following options, and then click Next:
      • Member key: Account_id
      • Parent key: Account_parent
      • Member name: Account_id
   4. In the Select advanced options page, click Deselect All, and then click Next.
   5. For the Dimension name value, type PrivateAccount, clear the Share this Dimension with other cubes check box, and then click Finish.
7. Save and process the Budget cube.
8. Quit Cube Editor.
9. Expand the Budget cube folder, right-click Cube Roles, and then click Manage Roles.
10. In the Cube Role Manager dialog box, click the All Users role, and then click Edit.
11. Click the Dimensions tab, and then set the Rule column value to Custom for the PrivateAccount dimension.
12. Click the . (ellipsis) button in the Custom Settings column of the PrivateAccount dimension.
13. In the Custom Dimension Settings: Budget^PrivateAccount dialog box, set the following options:
    • Basic tab:
      • Top Level: Level 02
      • Bottom Level: Level 04
      • Select members: Deselect all members
      • Members pane: check member [5000]
    • Common tab:
      • Click Enable-Show visual totals in Visual Totals, and then click OK.
14. Click OK in the Edit a Cube Role dialog box.
15. Click Test Role. "#Err" appears in the MeasuresLevel column of the result set.
16. Run the following MDX query in the MDX Sample application, and "#Err" is displayed in the result set (do not run the query as a member of the OLAP Administrators group):

    Select {[Measures].[Amount]} on Rows, {[5000]} on Columns from budget