Show Un-Compounded Key (Specifics for SAP BW)

Display an SAP BW un-compounded key in an SAP Analytics Cloud story when you want to see the part of a compounded key that makes sense in the current query context.

Restriction

The option to show un-compounded keys is available for SAP BW and SAP BW/4HANA, but only for optimized view mode and the optimized story experience.

For more information on the optimized story experience, see Optimized Story Experience.

You may need to apply a support package for this feature to work. For information on which support package to apply, refer to the following SAP Note:

  • SAP Note 3159902 Information published on SAP sitedesc: InA: Support Mixed Display Key

You can enable a setting that displays un-compounded keys in your stories.

Example

Your data includes regions and countries, but a region is not uniquely identifiable without the country. If there is no filter set on the country, you always see the compounded key.

However, if you restrict a widget to a single country, you will want to see the un-compounded key. (This restriction can happen via story filter, page filter, or widget filter.)

Only the key display of the member values is changed, not the description fields. This means that there is a difference only if the widget shows the key for a dimension.

How to Include Un-Compounded Keys in Your Story

  1. In SAP Analytics Cloud, select Start of the navigation pathSystem Next navigation step AdministrationEnd of the navigation path.

  2. In the System Configuration tab, set the toggle for Enable un-compounded display keys to ON.

Restrictions for Un-Compounded Key Display

After you enable un-compounded key display, there are some circumstances that won't allow the un-compounded key to be displayed. In those situations, the compounded key is displayed.

Persisted InA Enabled Story

You will still see compounded keys when you open an existing Persisted InA-enabled story. However, if you re-save the story and refresh it, you will see the uncompounded keys.

Widget-Specific Filters

Filters that are added to charts and tables (and appear in the Applied to Chart or Applied to Table context menu) will always show the compounded key.

Include, Exclude, Tuple, and Hierarchy Filters

When filters interact with each other (for example including some values but excluding others), the system will always show the compounded key.

Tuple filters may be able to display an un-compounded key, however, when those filters interact with other filters, only compounded keys will be displayed.

Hierarchy node filters that have one leaf, but also have the instruction to convert to flat selection won't display an un-compounded key.

DISPLAY_KEY Property

If you add the DISPLAY_KEY property to a table dimension, the compounded key is displayed instead of the un-compounded key.