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
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 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
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 expressions use the IF operator to compare a category, or to compare a date or a category with an AND.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-07-22 14:42:36 |
Date Created: | 2019-07-18 14:57:15 |