Microsoft KB Archive/827967

= You receive an &quot;Unable to parse the subcube MDX expression in the CREATE CELL FORMULA statement&quot; error when you edit a calculated cell in SQL Server 2000 Analysis Services =

Article ID: 827967

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



SYMPTOMS
When you try to edit a calculated cell by using the Calculated Cells Wizard in the Cube Editor, you may receive the following error message:

Unable to parse the subcube MDX expression in the CREATE CELL FORMULA statement. Subcube MDX expressions can only be edited using MDX Builder.

This problem may occur if the calculation subcube of the calculated cell is defined by using a Multidimensional Expressions (MDX) expression that includes a dimension that is involved in a dimension hierarchy.



CAUSE
The Calculated Cells Wizard does not have a complete MDX parser. Therefore, the Calculated Cells Wizard cannot interpret the MDX expression that is used to define the calculation subcube. This causes the error message that is mentioned in the &quot;Symptoms&quot; section.



WORKAROUND
To work around this problem, you must manually edit the Calculation Subcube value of the calculated cell without using the Calculated Cells Wizard in the Cube Editor.



MORE INFORMATION
This behavior may occur when the calculation subcube of a calculated cell is defined to use the A single member or the Descendants of a member member set of the hierarchy dimension.

Keywords: kberrmsg kbwizard kbdatabase kbprb KB827967

-

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

© Microsoft Corporation. All rights reserved.