Problem Note 66179: Data source filters that use parameters might not return expected results in SAS® Visual Analytics
 |  |  |  |  |
In some scenarios, data source filters that are based on a calculated item (which is based on parameters) might not return expected results in report objects.
For example, in the following report, when you click Sales in the button bar, the expected behavior is that all report objects display values. When you click Purchasing, report objects display no values.
The calculated item (called Filtervalue) contains the following:
RETURN '0'
ELSE (
IF ( 'Selection Parameter'p Contains 'Purchasing' )
RETURN '0'
ELSE (
IF ( 'Selection Parameter'p Contains 'Sales' )
RETURN '1'
ELSE '0' ) )
The data source filter contains the following:
However, when you click Sales in the button bar, the Key Value displays correct values, but other report objects are empty.
If you save the report with the Sales value selected in the button bar and you switch to Viewer, all report objects show values.
As a workaround, you can add an expression similar to the following in the data source filter:
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.5 | 9.4 TS1M6 | ||
| Linux for x64 | 7.5 | 9.4 TS1M6 | ||||