Problem Note 64277: "Detailed data" option in the Export Data dialog box is missing or it returns "expected parameter: # was not found" in a SAS® Visual Analytics report
Overview
Depending on which application you are using, you might encounter one or both of these two issues when attempting to export detailed data from a SAS Visual Analytics report:
- In SAS Visual Analytics, you see the following error when you select Detailed data in the Export Data dialog box:
The expected parameter: # was not found. An error occurred.
- In SAS® Report Viewer, the Detailed data option is missing from the Export Data dialog box.
Note: There are valid reasons why Detailed data is not available. For example, Detailed data is not available for objects that have a post-aggregate filter. To determine whether you are encountering the problem described in this note, attempt to export detailed data from SAS Visual Analytics. If you also see the error, then you are encountering this issue.
Cause
These problems can occur if the report includes a calculated data item that uses a parameter in an IF/ELSE expression. Here is an example:
IF ( 'MyMeasure Parameter'p Contains 'Revenue' )
RETURN 'Revenue'
ELSE 'Profit'n
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
SAS System | SAS Visual Analytics | Linux for x64 | 8.3 | 8.4 | Viya | Viya |
Microsoft® Windows® for x64 | 8.3 | 8.4 | Viya | Viya |
SAS System | SAS Report Viewer | Microsoft® Windows® for x64 | 8.3 | 8.4 | Viya | Viya |
Linux for x64 | 8.3 | 8.4 | Viya | 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: | high |
Date Modified: | 2019-09-27 11:04:13 |
Date Created: | 2019-05-31 16:13:05 |