Problem Note 68581: SAS® Visual Analytics report objects based on an aggregated data source might return the error "The column referenced by the query could not be found"
In SAS Visual Analytics, the following error might appear when you navigate your reports:
The column referenced by the query could not be found.
This problem especially occurs if your report objects are based on aggregated data sources that contain calculated items that are based on parameters.
For example, you might encounter this issue if you perform steps similar to the following:
- Create a new report and add a data source. This example uses the CARS data source.
- Add a drop-down list as a report control and select a data item as the Category Role. This example uses the Origin data item.
- Add a new category parameter (Parameter1) and add it as Parameter Role for the drop-down list:
- Create a new calculated item that is based on the parameter.
- Select the CARS data source in the Data panel and select the NEW DATA FROM AGGREGATION option.
- Select some data items and include the calculated item as well.
- Now, this report contains a new data source called CARS_AGGREGATED. Select CARS_AGGREGATED in the Data panel and use it to add roles to the list table. Select Origin, Horsepower, Invoice, and the Calculated Item:
- Save the report.
- In the drop-down list, select Asia as the value and note that the table below is correctly updated:
- However, if you select another value from the drop-down list control, such as Europe, an error occurs:
As a workaround, you can do the following:
- Edit the aggregated data source from Data ► Edit aggregated data and perform any actions. For example, move a data item up or down or add any additional data items. Then, save the aggregated data source. After this action, the problem does not occur anymore.
- Alternately, to avoid this problem, add the calculated data item in the aggregated data source as the last one.
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 (on SAS Viya) | Cloud Foundry | 8.5.1 | 2020.1.5 | Viya | Viya |
Linux for x64 | 8.5.1 | 2020.1.5 | 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: | 2021-12-07 15:07:48 |
Date Created: | 2021-11-05 10:52:40 |