Problem Note 64489: SAS® Visual Analytics displays "An error occurred" when aggregated measures that use Boolean operators are added to an object
 |  |  |  |  |
Overview
SAS Visual Analytics might display "An error occurred" when you add an aggregated measure that uses Boolean operator to an object such as a list table. Typically, the problem occurs for these types of expressions:
- The IF operator is used to compare a category.
- The IF operator is used to compare a date or a category combined with an AND.
Following are some examples.
The IF Operator Compares a Category
Here is the aggregated measure expression:
Here is the error displayed in a list table object:
The IF Operator Compares a Date or Category Combined with an AND
Here is the aggregated measure expression:
Here is the error displayed in a list table object:
Workaround
Create new numeric data items to replace the conditions that cause this issue. For example:
1. Create a new measure and set it equal to 1 or 0.
2. Create a new aggregated measure using the Flag data item for the comparison.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics (on SAS Viya) | Microsoft® Windows® for x64 | 8.3.1 | Viya | ||
| Linux for x64 | 8.3.1 | Viya | ||||
| Cloud Foundry | 8.3.1 | Viya | ||||
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.5 | 9.4 TS1M6 | ||
| Linux for x64 | 7.5 | 9.4 TS1M6 | ||||
A fix for this issue for SAS Visual Analytics 7.51 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9T.html#64489A fix for this issue for SAS Visual Analytics 7.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F9L.html#64489| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-07-22 14:42:36 |
| Date Created: | 2019-07-18 14:57:15 |