FIX: Dimension Wizard Generates Unusable Custom Rollup Formula with Private Parent-Child Dimension

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q289804

BUG #: 11617 (plato7x)

SYMPTOMS

If you use the Dimension Wizard to create a private Parent-Child dimension with the Data members are hidden option selected, the Custom Rollup Formula generated by the wizard is:

CalculationPassValue([~New Cube^DimensionName].CurrentMember.DataMember, 0)

If you attempt to browse the data after processing the cube, #ERR is seen. If you click #ERR, the following error message displays:

Unable to display cell properties. Formula error - cannot find dimension member ("[~New Cube^DimensionName]") - in a name binding function An error occurred during attempt to get a cell value.

Back to the top

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

Steps to Reproduce Behavior

Open the Analysis Manager.
Open the Foodmart 2000 database.
Create a new cube by using the Cube wizard.
Select Sales_fact_1997 as the fact table, and then select Unit Sales as the measure.
Click New Dimension to create a new private parent-child dimension.
In the Select The Dimension Table dialog box, click Employee, and then click Next.
To define the child column, next to the "Member" key, select employee_id. To define the parent column, next to the "Parent" key, select supervisor_id. To define the "Member name" column, next to "Member" name, select full_name. Click Next.
Select Members with data in the Select Advanced Options dialog box. Click Next.
In the Set Members with Data Property dialog box, select Nonleaf members have associated data, and then select Data members are hidden. Click Next.
Type Private Employee Dim for the dimension name. Clear the Share this dimension with other cubes check box, and then click Finish.
Type Parent_child_cube for the cube name. Click Finish to advance to the Cube editor.
Highlight the dimension level Employee_ID under Private Employee Dim.
Click the Advance tab under Properties to see the Custom Rollup Formula.
Build the cube into a MOLAP cube, and then browse the data.

Back to the top

APPLIES TO

Microsoft SQL Server 2000 Analysis Services

Back to the top

kbbug kbfix kbssas800sp1fix KB289804

Back to the top

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