SAP Knowledge Base Article - Public

3209055 - Default ID and Description display in value help (F4) for BW Live model

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

Product

SAP Analytics Cloud all versions