Problem Note 67530: An error occurs when SAS® Visual Analytics report objects are filtered with the DateTimeFromTimeMDY or the TimePart operator and/or the Now() function
SAS Visual Analytics report objects might return an error if the data source filter includes the DateTimeFromTimeMDY operator, the TimePart operator, and/or the Now() function. In this scenario, either some report object sections or the entire report object might fail with a red 'x' and the following error:
An error occurred.
The error does not occur if you use the DateTimeFromTimeMDY operator, the TimePart operator, and/or the Now() function in a filter directly on the report object.
The following SAS® Visual Statistics report objects are affected:
- Decision Tree
- Generalized Additive Model
- Nonparametric Logistic Regression
The following SAS® Visual Data Mining and Machine Learning report objects are affected:
- Forest
- Gradient Boosting
- Neural Network
As a workaround, first create a calculated date/time data item that includes the operator or function in the expression. For example, the expression for dateTime_Calc would be as follows:
DateTimeFromTimeMDY(TimePart(Now()), 1, 1, 2021)
Next, reference the calculated date/time data item in the data source filter. For example, the data source filter would be as follows:
'dateTimeValue'n >= 'dateTime_Calc'n
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 | |
*
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.
Several SAS® Visual Analytics report objects might return "An error occurred" if the data source filter includes the DateTimeFromTimeMDY operator, the TimePart operator, and/or the Now() function.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2021-05-25 10:47:58 |
Date Created: | 2021-03-02 12:45:36 |