Article ID: 296419 - View products that this article applies to.
This article was previously published under Q296419
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 11250 (Plato7.x)
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.
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.
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:
(https://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
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.
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.
Article ID: 296419 - Last Review: October 23, 2013 - Revision: 1.2