Problem Note 56616: Filtering fails in Portfolio Details when you use a second or third subcube
 |  |  |  |
When you filter the Portfolio Details in SAS® High-Performance Risk 3.3 or 3.4, the resulting filter values might be incorrect. However, there are no errors or warnings.
This issue is specific to applying a filter while viewing Portfolio Details in a comparison join cube. In the user interface (UI), when you drag a horizon onto a crosstab matrix and filter the data, you can right-click within those results and choose to see the Portfolio Details. When viewing the Portfolio Details, you can then apply a filter by using the menu on the right.
When filtering on horizons for the first subcube (any horizon that has a "1" in front of it), if you right-click the subcube, select Portfolio Details, and specify a filter, the filter works as expected and the proper range is used. For example, if you create and apply a filter in the UI with specified min/max values, the filter values reflect the min/max values for the details that you are viewing.
However, if you then drag over a horizon from the second subcube (any horizon that has a "2" in front of it) and view the Portfolio Details for that horizon, the range values used when you apply a filter might be incorrect. For example, if you create a filter in the UI with specified min/max values and click Apply, the displayed slider min/max values for that instrument variable might be incorrect. They might even be outside the range that you specified for the filter.
The only workaround is to use just one subcube.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS High-Performance Risk | Microsoft® Windows® for x64 | 3.3 | 3.5 | 9.4 TS1M2 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 3.3 | 3.5 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 3.3 | 3.5 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Linux for x64 | 3.3 | 3.5 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Solaris for x64 | 3.3 | 3.5 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2015-09-29 18:00:31 |
| Date Created: | 2015-09-18 11:56:57 |