SAP Knowledge Base Article - Public

3446595 - The value help of the prompt's variable of an Analytic Model does not show the description

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

  1. Open the Analytic Model in Data Builder;
  2. Click on "Preview" to display AM data;
  3. Filter variable is offered at the prompt;
  4. Use value help to show the corresponding values and display "ID and Description". The description does not appear, only the ID:
     

or

  1. Open the Analytic Model in the Data Builder;
  2. Edit filter variable;
  3. Try to set a default value, opening the value help:
  4. 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: 

  1. Dimension and text table should have the same key fields, except that the text table get the additional language or/and time dependency fields

  2. For an example value, check if the value exists in the dimension table and in the text table 

  3.  Check if the language field is correctly assigned with semantic type "Language": 

  4. 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

Add a Variable

Creating an Analytic Model

Keywords

text association, F4, value help, Source Variable, Filter Variable, input help , KBA , DS-MD-AM , Analytic Model , Problem

Product

SAP Datasphere all versions

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