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

Article translations Article translations
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)
Expand all | Collapse all

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.

Properties

Article ID: 296419 - Last Review: October 23, 2013 - Revision: 1.2
APPLIES TO
  • Microsoft SQL Server 2000 Analysis Services
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbssas800sp1fix KB296419

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com