Microsoft KB Archive/296419

= FIX: Cannot Set Parent for Calculated Member to Member of Parent-Child Dimension =

Article ID: 296419

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q296419



BUG #: 11250 (Plato7.x)



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.

Additional query words: Parent Child MDX Member OLAP

Keywords: kbbug kbfix kbssas800sp1fix KB296419

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.