SUPPORT / SAMPLES & SAS NOTES
Problem Note 57712: Filters are ignored after you change slicer settings in a SAS® Financial Management read-only report
 |  |  |  |  |
In the SAS Financial Management Add-In for Microsoft Excel, the custom properties of members have the same potential uses as the standard properties. You can use the values of custom properties to filter dimension members when you use them as slicers in a read-only report.
In a read-only table with multiple slicers, if there is no data that matches the slicer settings, the read-only table shows an empty pink cell. This is expected behavior. After the pink cell is displayed, if you change the table slicers to a valid member combination, the filter is ignored and all dimension member crossings are displayed instead.
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 Financial Management | Microsoft® Windows® for x64 | 5.5 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 5.5 | 9.4 TS1M3 | ||||
| 64-bit Enabled Solaris | 5.5 | 9.4 TS1M3 | ||||
| Linux for x64 | 5.5 | 9.4 TS1M3 | ||||