Symptom
A variable was created in the SAP Datasphere Analytic Model. During the preview, if a single number without leading 0s is entered directly into the variable selection (e.g. "123" instead of "0000000123") the correct number is found:
However, the clipboard option behavior is different and the message "Some values could not be found and were not applied to the variable" appears:
Environment
SAP Datasphere
Reproducing the Issue
- Create a variable in the Analytic Model;
- Perform the preview;
- Click on "Clipboard" icon;
- Input "123" and click on "Ok", message "Some values could not be found and were not applied to the variable" raises.
Cause
The reason why the clipboard validation works differently than the direct input is that they are designed for different use-cases. Entering a value directly into the variable dialog accepts incomplete value of the ID like "123". This performs wildcard search for the input. This is an expensive search on the backend which is okay for a single value.
Resolution
Behavior is expected.
The idea behind the clipboard was that the user copies a big list of complete IDs from an Email or any other source. Performing the same search mentioned in the section "Cause" for many values is unwanted due to the cost. Instead, it performs a quick validation for the items existence using the exact ID.
See Also
Keywords
Source Variable, clipboard, Restricted Measure Variable, Reference Date Variable, filter, dwc, DSP , KBA , DS-MD-AM , Analytic Model , Problem