Help and Support
 

powered byLive Search

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
Last Review:October 15, 2007
Revision:1.5

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.

Back to the top

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

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.

Back to the top

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.

Back to the top


APPLIES TO
Microsoft Office Visio Professional 2007

Back to the top

Keywords: 
kbtshoot kbprb kbexpertiseinter kbexpertisebeginner KB918722

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.