Story-Specific Considerations for SAP BW Live Data Connections

There are some usage restrictions and some features to be aware of when creating stories using a live data connection to SAP BW or SAP BW/4HANA.

For information on unsupported features with SAP BW, SAP S/4HANA and SAP BPC Live Connections in SAP Analytics Cloud, see 2788384 Information published on SAP site .

Universal Display Hierarchy Support in SAP Analytics Cloud

Universal Display Hierarchy is a BW Query setting that allows two or more dimensions defined in the rows or columns to be displayed hierarchically. This setting can be activated in the rows or columns of a table.

Restriction

The Universal Display Hierarchy setting is not supported for chart visualizations. It is only supported for table visualizations.

SAP BW-Specific Topics

The following topics provide additional information to consider when working with SAP BW and stories. Even though the title only includes “(Specifics for SAP BW)”, the information is also valid for SAP BW/4HANA connections.

Feature	Description
Calculation Editor (Specifics for SAP BW)	Learn about specifics on SAP BW live data connections when using the calculation editor.
Create Custom Group Hierarchies (Specifics for SAP BW)	If the SAP BW live data that you're working with doesn't have a hierarchy that is organized in the way that you'd like, you can create your own custom group hierarchies in your story.
Currency Conversion (Specifics for SAP BW)	Convert the same currency or mixed currency values to another currency.
Custom Hierarchies on Choropleth Layer (Specifics for SAP BW)	Apply user-defined hierarchies with custom shape files in the geo choropleth layer.
Linked Dimension on Shared Hierarchies (Specifics for SAP BW)	You can link on two dimensions with active hierarchies in two different SAP BW data sources.
Performance Optimization (Specifics for SAP BW)	Learn how you can improve performance when working with the live data connection to SAP BW.
Story and Page Filter (Specifics for SAP BW)	You use the story or page filter with cascading dimensions.
Searching in Filters and Input Controls (Specifics for SAP BW)	Learn about specifics on SAP BW live data connections when searching in filters or input controls.
Input Controls: Single Selection Choices for Filters (Specific to SAP BW)	In your input control and filter settings, you can choose to allow the selection of both parents and their children, rather than one or the other.
Pasting Values into Page Filters (Specifics for SAP BW)	When working with SAP BW live data sources, you can paste values into your story or page filter from a list.
Show Un-Compounded Key (Specifics for SAP BW)	Display the un-compounded key in a story when you want to see the part of a compounded key that makes sense in the current query context.
Tables (Specifics for SAP BW)	Learn about specifics on SAP BW live data connections when working with tables.
Time Dimensions in SAP Analytics Cloud (Specifics for SAP BW)	Guidelines for using SAP BW time dimensions in SAP Analytics Cloud.
Time-Based Variances (Specifics for SAP BW)	You can create a time-based variance in a chart that uses data from SAP BW live data sources, but there are some usage restrictions.
Time Series Charts (Specifics for SAP BW)	You can use time series charts with level-based hierarchies.