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.

Back to the top

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 source name 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.

Back to the top

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.

Back to the top

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.

Back to the top