SAP Analytics Cloud Support Matrix for Live Connectivity to SAP NetWeaver BW and SAP BW/4HANA

See what SAP NetWeaver BW and SAP BW/4HANA query functionality is compatible with SAP Analytics Cloud.

Note
For information on supported versions of SAP BW and SAP BW/4HANA, see System Requirements and Technical Prerequisites.

BEx Query Elements

SAP Analytics Cloud

(BW Live Connection)

Notes

InfoProvider Dimension

No

Creation of custom groups on dimensions can be done via the Modeler.

Characteristics

Yes

 

Key Figures

Yes

 

Free Characteristics

Yes

SAP Analytics Cloud does not have a "Free Characteristics" concept in product. However, the Free Characteristics are made available for use in Story visualizations.

Restricted Key Figures

Yes

When using data from SAP BW, creating a restricted measure on another restricted measure (referred to as a key figure in SAP BW) that uses the same dimension results in incorrect data in SAP Analytics Cloud. A further restriction is not possible because SAP BW treats restrictions as OR operations. In most cases restricted measures are intended to get the result as an AND operation.

For example, COUNTRY is restricted to Great Britain and Germany. In a sales scenario, the intended result would be that you see products that are sold in both countries (Great Britain OR Germany) and not a combination of either country and both of them (Great Britain OR Germany OR (Great Britain AND Germany)).

Calculated Key Figures

Yes

 

Display Attributes

Yes

Attributes can be displayed in Table visualizations. Chart visualizations do not support Attribute display.

Navigational Attributes

Yes

 

BEx Query Filter (defined under Characteristic Restrictions)

Yes

 

BEx Query Filter (defined under Fixed Values)

Yes

 

BEx Query Filter (defined under Default Values)

Limited Support

Range filters are not supported. Please use fixed filters instead.

Mixing include and exclude members is not supported.

Custom Key Figure Structure

Yes

 

Custom Characteristic Structure

Yes

See restrictions below for "Support for 2 structures from BEx Query" in the Explorer.

Hierarchical Custom Key Figure Structure

Yes

Hierarchical measure structures will be displayed as flattened measures in chart visualizations.

Hierarchical Custom Characteristic Structure

Yes

See restrictions below for "Support for 2 structures from BEx Query" in the Explorer.

Support for 2 structures from BEx Query

Yes

The Explorer does not support SAP BW queries with a second Structure, but you can visualize such SAP BW queries in table and chart widgets. Search to Insight does not support SAP BW queries with two characteristic structures.

Compounded Characteristics

Limited Support

Key display Mix Compounded has limited support.

For more information, see Show Un-Compounded Key (Specifics for SAP BW)

Recommendation: If context in visualization is clear to the end user, do not show the compounded parent characteristic.

For Compounded Dimensions, the Key display will always be compounded. (Exception: in case of prompts, not compounded will always be shown.)

Support for Characteristic Data Type NUMC

Yes

 

Support for Characteristic Data Type CHAR

Yes

 

Support for Characteristic Data Type DATS

Yes

 

Support for Characteristic Data Type TIMS

Limited Support

Chart, table, and filter widgets do not support sorting based on the Data Type TIMS.

Dimensions of the Data Type TIMS are not supported in Charts.

Support for Key Figures Data Type Number / Integer /Amount / Currency

Yes

 

Support for Key Figures Data Type DATS

Yes

Key Figures of type DATS and TIMS are relevant only for Table visualizations.

They cannot be used with Chart visualizations.

Support for Key Figures Data Type TIMS

Yes

Key Figures of type DATS and TIMS are relevant only for Table visualizations.

They cannot be used with Chart visualizations.

Information about configured Filters in the BEx Query

No

 

BEx Text Elements

No

 

Support for Conversion EXIT

Yes

 

Variables in BEx Query

SAP Analytics Cloud

(BW Live Connection)

Notes

Optional Variables

Yes

 

Mandatory Variables

Yes

 

Characteristic Value Variables

Yes

 

Formula Variables

Yes

 

Hierarchy Variables

Yes

 

Hierarchy Node Variables

Yes

 

Hierarchy Version Variable

Yes

Information about the version as part of hierarchy description names is not supported.

Key Date Variable

Yes

 

Text Variables

Yes

 

Variable Processing Type: User Entry / Default Value

Yes

 

Variable Processing Type: Replacement Path

Yes

For the variable processing type Replacement Path: Variables with replacement from the query result are not supported when the second query also has variables that are configured as ready for input.

Variable Processing Type: Customer / SAP Exits

Yes

 

Variable Processing Type: Authorization

Yes

 

Variable Representation : Single Value

Yes

 

Variable Representation : Multiple Single Value

Yes

 

Variable Representation : Interval (Range) Value

Yes

 

Variable Representation : Selection Option

Yes

 

Variable Representation : Selection Option Operator Functionality (except Contains Pattern)

Yes

 

Variable Representation : Selection Option Operator Functionality – Contains Pattern

No

 

Variable Representation : Selection Option Include / Exclude Functionality

Yes

 

Variable Representation : PreCalculated Value Set

Yes

 

Support for manual entry of values

Yes

Only manual entry by Key value is supported.

Support for Variables in Defaults Values area of BEx Query

Yes

 

Support for single Key Date Variable

Yes

 

Support for multiple Key Date Variables in single BEx Query

Yes

 

Support for cascading Hierarchy / Hierarchy Node Variable dependency

Yes

 

Support for cascading variables for Compounded Characteristics

Yes

 

Support for Variable Default Values

Yes

 

Support for BW Variable Variants

Yes

 

Support for BW Variable Personalization

Yes

Consumption only. Management of personalization values can be achieved using BEx Analyzer.

Merge / Unmerge Variables

Yes

Merge is based upon the technical IDs of the prompts.

Variable Sequence based on BEx Query Designer

Yes

 

Support for validating values before executing the report

Yes

Syntactic validation happens upon submission of selected prompt values to SAP BW.

Read Mode for list of values (masterdata, InfoCube)

Yes

 

List of Values : Search in Key values

Yes

 

List of Values : Search in Description Values

Yes

 

List of Values : Sort values based on Key Values

No

Sorting based on user preference is not supported.

List of Values : Sort values based on Description Values

No

Sorting based on user preference is not supported.

BEx Query Functionality

SAP Analytics Cloud

(BW Live Connection)

Notes

Currency / Unit Conversion (defined in BEx Query)

Yes

 

Currency / Unit Conversion (defined at the client level)

No

 

Condition in Rows (from BEx Query)

Yes

 

Condition in Columns (from BEx Query)

Yes

 

Conditions for fixed set of characteristics (from BEx Query)

Yes

 

Condition for independent characteristics (from BEx Query)

Yes

 

Exceptions (defined in BEx Query)

No

Exceptions defined in a BEx Query will be ignored.

Workaround: You can use the Conditional Formatting / Set KPI feature set in Chart and Table visualizations.

Constant Selection

Yes

 

Cell Editor Calculation

Yes

Cell Editor calculated values will be exposed in SAP Analytics Cloud.

Local calculations (defined in BEx Query)

Yes

 

Exception Aggregation

Yes

 

Zero Suppression

Yes

 

Read Mode for characteristics in BEx Query (result values, filter values)

Yes

The Read Mode for filter values can optionally be changed in the Filter Dialog of SAP Analytics Cloud (i.e., the setting can be either the booked value or masterdata).

Read Mode for characteristics in InfoObject

Yes

The Read Mode for filter values can optionally be changed in the Filter Dialog of SAP Analytics Cloud (i.e., the setting can be either the booked value or masterdata).

Display Settings in BEx Query

SAP Analytics Cloud

(BW Live Connection)

Notes

Scaling Factor

Limited Support

Scaling defined on Key Figures in the BEx Query will be mapped into SAP Analytics Cloud's scaling concept.

However, SAP Analytics Cloud's scaling concept is currently limited to scale factors of 1, 1000, Million, and Billion. In cases where BW Scaling cannot map directly into SAP Analytics Cloud's scaling concept, the scaling will be set to 1 for the Key Figure represented in SAP Analytics Cloud. The application scaling concept can be applied afterward.

Reverse Sign (+/-)

Yes

 

Number of Decimals

Yes

Numbers, Dates, and Time can also be formatted according to the User Profile settings in SAP Analytics Cloud.

Hide / Show the Element

Yes

 

Sort Characteristics

Yes

Member Sort or Value-based Sort can be manually applied for Chart and Table visualizations. This will override the Default sort behavior.

Display Options for characteristics (Key, Key & Text, Text)

Yes

Users can switch between ID/Description during Story design. The ability to switch between Short, Medium, and Long presentations of Description is not supported.

Result Rows (Show, Suppress)

Yes

 

Placement of subtotal (above / below nodes)

Yes

It is possible to enable Totals display in the Story for Table visualizations only.

Activate Hierarchy

Yes

A non-activated hierarchy is presented as an active hierarchy on the table if the query shows a value in the hierarchy's Name field.

To ensure that the hierarchy is properly deactivated, you need to click the Clear Hierarchy button.

Hierarchical Functionality

SAP Analytics Cloud

(BW Live Connection)

Notes

Support for Hierarchies with Linked Nodes

No

 

Support for version-dependent Hierarchies

No

 

Support for time-dependent Hierarchies

Limited Support

Please refer to SAP Note 3081404 Information published on SAP site.

Support for time-dependent Hierarchy Structures

Limited Support

Please refer to SAP Note 3081404 Information published on SAP site.

Support for Text of External Characteristics in Hierarchies

Limited Support

If the base characteristic of the hierarchy doesn't have text, but the other external characteristics do have text, then those texts won't be displayed correctly.

Support for Hierarchies with Temp Join

Yes

 

Show specific Hierarchy Levels (defined in the BI client)

No

 

Skip levels of a hierarchy (defined in the BI client)

No

 

Show Leaf Members only (defined in the BI client)

No

 

Expand to Level Functionality (BEx Query Designer)

Yes

Expand to Level setting defined in the BEx Query is supported for Tables only.

Expand to Level Functionality (defined in the BI client)

Yes

Drill level capability for Tables only.

Drill level capability is not offered for Chart visualizations.

Hierarchical Charting

Yes

 

Exchange of hierarchies

Yes

 

Display as Hierarchy (Universal Display Hierarchy)

Yes

Not supported by SAP BW 7.4 release versions.