Article ID: 918722 - Last Review: October 15, 2007 - Revision: 1.5 Nodes that do not match the value of the filter are displayed when you apply a filter to a PivotDiagram in Visio 2007SYMPTOMSYou create a PivotDiagram in Microsoft Office Visio 2007. You use a Microsoft SQL Server Analysis Services Online Analytical Processing (OLAP) cube as the data source for the PivotDiagram. When you apply a filter to data in the PivotDiagram, the filter is not applied. Instead, nodes that do not match the value of the filter are displayed. CAUSEThis issue occurs if you apply a floating-point equality filter to data in the PivotDiagram. The rounding of values that occurs when you apply a filter in the Configure Measure dialog box means that values that are returned may not always match the floating-point values. This issue is mostly likely to occur when you use any one of the following conditions in the filter:
WORKAROUNDWhen you apply a floating-point equality filter, use a condition other than is greater than or equal to or is less than or equal to. MORE INFORMATIONFor more information about how to work with PivotDiagrams in Visio 2007, click Microsoft Office Visio Help on the Help menu, type Pivotdiagram, and then click Search to view a list of relevant topics.
| Article Translations
|
Back to the top
