Symptom
During the preview of Analytic Model, the value help of the prompt's variable does not show the description. However, the text/description for the dimension is displayed in the preview of the Analytic Model.
Reproducing the Issue
- Open the Analytic Model in Data Builder;
- Click on "Preview" to display AM data;
- Filter variable is offered at the prompt;
- Use value help to show the corresponding values and display "ID and Description". The description does not appear, only the ID:
or
- Open the Analytic Model in the Data Builder;
- Edit filter variable;
- Try to set a default value, opening the value help:
- There no description in value help:
Cause
Scenario 1:
Dimension has a compound key with another dimension. Therefore, in the prompt of the filter variable, the text is not appearing.
Scenario 2:
There is no compounding. Data in the text table does not match the keys of the dimension table.
Resolution
Scenario 1:
Currently, this is not supported. Development team is discussing to decide if this scenario will be possible.
Scenario 2:
- Dimension and text table should have the same key fields, except that the text table get the additional language or/and time dependency fields
- For an example value, check if the value exists in the dimension table and in the text table
- Check if the language field is correctly assigned with semantic type "Language":
- The system can resolve several language representations with a single character:
- 1 character language field (as it comes from abap systems Example: E)
- 2 characters (EN)
- so code (EN-US).
The logic happens depends on the length of the language field. Check the length of the language field that it matches to the data in that column.
See Also
Keywords
text association, F4, value help, Source Variable, Filter Variable, input help , KBA , DS-MD-AM , Analytic Model , Problem
Product
Attachments
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
SAP Knowledge Base Article - Public