You receive an "Unable to parse the subcube MDX expression in the CREATE CELL FORMULA statement" error when you edit a calculated cell in SQL Server 2000 Analysis Services (827967)
The information in this article applies to:
- Microsoft SQL Server 2000 Analysis Services
SYMPTOMSWhen 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. CAUSEThe 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 "Symptoms" section.WORKAROUNDTo 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 INFORMATIONThis 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.
| Modification Type: | Major | Last Reviewed: | 11/2/2004 |
|---|
| Keywords: | kberrmsg kbwizard kbDatabase kbprb KB827967 kbAudDeveloper |
|---|
|