FIX: Cannot Set Parent for Calculated Member to Member of Parent-Child Dimension (296419)

SYMPTOMS

When creating a calculated member in the calculated member builder, the text box and Change button for the parent member are not enabled if the parent dimension selection is a parent-child dimension and the parent-child dimension does not have an All Level.

CAUSE

The parent member determines the location of the calculated member in the parent dimension structure. The parent member option is enabled if you select a parent dimension (other than the Measures dimension) and that dimension has more than one level.

The code that enables the parent member option in the calculated member builder incorrectly interprets a parent-child dimension, without an All Level, to be a single level dimension and thus does not enable the text box or Change button.

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

WORKAROUND

Enabling the All Level for the parent-child dimension allows you to set the parent in the calculated member builder. After all of the calculated members for that dimension are created and verified, you can disable the All Level of the dimension and the calculated members still work as designed. However, you must re-enable the All Level to change the parent member to a different member in the parent-child dimension.

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.