Problem Note 69363: “Unknown data item” error might occur in SAS® Visual Analytics when you edit a calculated item
You might receive the message "Unknown data item" when you edit a calculated item. For example, you encounter this issue if you complete steps similar to the following:
- Create a new SAS Visual Analytics report based on a data source that contains a category data item called Origin.
- Add a new calculated item and save it with the name Origin (exactly the same name of the category data item that already exists in the data source). Then, you will have two data items with the same name in the same data source: a category data item and a calculated item.
- Add the following formula:
IF ( 'Origin'n = 'Asia' )
RETURN 'Asia'
ELSE 'OTHERS'
The calculated item is saved correctly, and you can display it in the Data pane. However, if you try to edit it, you can see that the name of the category data item in the formula Origin has been replaced with the name Origin1. This behavior causes the following error to occur if you perform any change in the calculated item and try to save it:
“Unknown data item: Origin1”
To work around this error, complete these steps:
- Create a copy of the category data item Origin and name it Origin_copy.
- When creating the calculated item, use the category data item Origin_copy within the formula instead of Origin. In this way, the calculated item called Origin is based on a copy of the Origin category data item and this prevents the issue from occurring.
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.2 | 2022.1 | Viya | Viya |
Linux for x64 | 8.5.2 | 2022.1 | 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: | 2022-08-04 09:07:21 |
Date Created: | 2022-07-01 03:13:15 |