Symptom
When select a value for a variable of a BW query in Value Help, the default display for "Show Description" is not the expected one. For example, you want to use "Description", but it shows "ID".
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP Analytics Cloud
Reproducing the Issue
Open Value Help for a variable of a BW query.
Resolution
The default value can be adjusted on the characteristic's property in the query definition.
Query Designer:
Hana Studio:
Addition:
1.This setting also effects the display for the characteristic in the table.
2.In Analysis for Office, the default display in the prompt will ignore the query definition as per Note 2555624 which might show a different result.
See Also
Note 2555624 Bex Variables: Query settings defined for characteristics are not taken into account
Keywords
F4-mode, input help, value help, Key, Text, Key/Text, ID and Description , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem