Microsoft KB Archive/316763

= BUG: Office XP PivotTable Query Fails With Member Property in Filter Expression of MDX =

Article ID: 316763

Article Last Modified on 1/30/2002

-

APPLIES TO


 * Microsoft Office Web Components

-



This article was previously published under Q316763



SYMPTOMS
When you apply a valid multidimensional expression (MDX) to the CommandText property of the PivotTable component, the query fails if the filter expression contains a member property. For example, the following MDX fails: SELECT {[Measures].defaultmember} ON COLUMNS, {          Filter( {[Store].[Store Name].Members},                       ([Store].CurrentMember.Properties(&quot;Store Manager&quot;) = &quot;Maris&quot;)) }      DIMENSION PROPERTIES [Store].[Store Name].[Store Manager] ON ROWS FROM sales



CAUSE
The PivotTable fails to process this MDX due to a problem with the parsing of the axis specification. When the axis specification contains the &quot;Properties&quot; keyword, the PivotTable assumes that it represents the start of the &quot;DIMENSION PROPERTIES&quot; section; this assumption is incorrect when a member property appears in the filter expression.



RESOLUTION
To work around this problem, remove the &quot;Properties&quot; keyword from the filter expression and instead use a calculated member for the condition. For example, you can use the following MDX in place of the MDX in the &quot;Symptoms&quot; section: WITH MEMBER [Measures].[Filter Condition] AS   'iif(Store.CurrentMember.Properties(&quot;Store Manager&quot;) = &quot;Maris&quot;, 1, null)' SELECT {[Measures].defaultmember} ON COLUMNS, {        Filter( {[Store].[Store Name].Members},                   [Filter Condition] =1) }    DIMENSION PROPERTIES [Store].[Store Name].[Store Manager] ON ROWS FROM sales



STATUS
Microsoft has confirmed that this is a problem in Office XP Web Components.

Additional query words: olap analysis services

Keywords: kbbug kbofficewebpivot kbpending KB316763

-

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

© Microsoft Corporation. All rights reserved.