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