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

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)
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 theMicrosoft 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.
Parent Child MDX Member OLAP
Properties

Article ID: 296419 - Last Review: 10/23/2013 18:36:19 - Revision: 1.2

  • Microsoft SQL Server 2000 Analysis Services
  • kbnosurvey kbarchive kbbug kbfix kbssas800sp1fix KB296419
Feedback