Microsoft KB Archive/918722

= Nodes that do not match the value of the filter are displayed when you apply a filter to a PivotDiagram in Visio 2007 =

Article ID: 918722

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Visio Professional 2007

-



SYMPTOMS
You 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.



CAUSE
This 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:
 * is greater than or equal to
 * is less than or equal to

For example, data in the PivotDiagram includes the value 107366.33. You apply a  is less than or equal to 107366.33 filter. In this scenario, nodes that contain the 107366.3 value are not displayed. Instead, nodes that contain a value that is more than 107366.3 may be displayed.



WORKAROUND
When 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 INFORMATION
For 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.

Additional query words: visio2007 visio2k7 visio12 vso2007 vso2k7 vso12

Keywords: kbtshoot kbprb kbexpertiseinter kbexpertisebeginner KB918722

-

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

© Microsoft Corporation. All rights reserved.