Problem Note 57025: SAS® Visual Analytics reports that use Parse and other string functions might perform slowly
If you use the Parse function in calculated items, aggregated measures, or filters, SAS Visual Analytics might perform slowly when rendering report objects that use those data items and filters. Ranking might be especially slow.
When attempting to process the Parse function, the server might evaluate the expression many times instead of just once. These additional evaluations can adversely affect report performance. For example, evaluating an expression might take several minutes instead of several seconds.
Note: The Parse function appears as INPUTN in the SAS® LASR™ Analytic Server and SAS® Cloud Analytic Services logs. Within the reportData log, Parse appears as applySASInformat.
As a workaround, avoid using the Parse function within your report. In some cases, you can use the original data items. In other cases, you must create the relevant data items before you load the data into memory.
Operating System and Release Information
SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.1 | | 9.4 TS1M2 | |
Linux for x64 | 7.1 | | 9.4 TS1M2 | |
SAS System | SAS Visual Analytics (on SAS Viya) | Linux for x64 | 8.5 | | Viya | |
Microsoft® Windows® for x64 | 8.5 | | 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.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2022-10-21 12:38:28 |
Date Created: | 2015-11-06 11:47:19 |