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

InfoProvider Dimension

Characteristics

Key Figures

Free Characteristics

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

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

Display Attributes

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

Navigational Attributes

BEx Query Filter (defined under Characteristic Restrictions)

BEx Query Filter (defined under Fixed Values)

BEx Query Filter (defined under Default Values)

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

Mixing include and exclude members is not supported.

Custom Key Figure Structure

Custom Characteristic Structure

Hierarchical Custom Key Figure Structure

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

Hierarchical Custom Characteristic Structure

Support for 2 structures from BEx Query

Compounded Characteristics

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

Support for Characteristic Data Type CHAR

Support for Characteristic Data Type DATS

Support for Characteristic Data Type TIMS

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

Support for Key Figures Data Type DATS

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

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

BEx Text Elements

Support for Conversion EXIT

Optional Variables

Mandatory Variables

Characteristic Value Variables

Formula Variables

Hierarchy Variables

Hierarchy Node Variables

Hierarchy Version Variable

Key Date Variable

Text Variables

Variable Processing Type: User Entry / Default Value

Variable Processing Type: Replacement Path

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

Variable Processing Type: Authorization

Variable Representation : Single Value

Variable Representation : Multiple Single Value

Variable Representation : Interval (Range) Value

Variable Representation : Selection Option

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

Variable Representation : Selection Option Operator Functionality – Contains Pattern

Variable Representation : Selection Option Include / Exclude Functionality

Variable Representation : PreCalculated Value Set

Support for manual entry of values

Only manual entry by Key value is supported.

Support for Variables in Defaults Values area of BEx Query

Support for single Key Date Variable

Support for multiple Key Date Variables in single BEx Query

Support for cascading Hierarchy / Hierarchy Node Variable dependency

Support for cascading variables for Compounded Characteristics

Support for Variable Default Values

Support for BW Variable Variants

Support for BW Variable Personalization

Merge / Unmerge Variables

Variable Sequence based on BEx Query Designer

Support for validating values before executing the report

Read Mode for list of values (masterdata, InfoCube)

List of Values : Search in Key values

List of Values : Search in Description Values

List of Values : Sort values based on Key Values

List of Values : Sort values based on Description Values

Currency / Unit Conversion (defined in BEx Query)

Currency / Unit Conversion (defined at the client level)

Condition in Rows (from BEx Query)

Condition in Columns (from BEx Query)

Conditions for fixed set of characteristics (from BEx Query)

Condition for independent characteristics (from BEx Query)

Exceptions (defined in BEx Query)

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

Cell Editor Calculation

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

Local calculations (defined in BEx Query)

Exception Aggregation

Zero Suppression

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

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

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).

Scaling Factor

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 (+/-)

Number of Decimals

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

Hide / Show the Element

Sort Characteristics

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)

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)

Placement of subtotal (above / below nodes)

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

Activate Hierarchy

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.

Support for Hierarchies with Linked Nodes

Support for version-dependent Hierarchies

Support for time-dependent Hierarchies

Please refer to SAP Note 3081404 .

Support for time-dependent Hierarchy Structures

Please refer to SAP Note 3081404 .

Support for Text of External Characteristics in Hierarchies

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

Show specific Hierarchy Levels (defined in the BI client)

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

Show Leaf Members only (defined in the BI client)

Expand to Level Functionality (BEx Query Designer)

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

Expand to Level Functionality (defined in the BI client)

Drill level capability for Tables only.

Drill level capability is not offered for Chart visualizations.

Hierarchical Charting

Exchange of hierarchies

Display as Hierarchy (Universal Display Hierarchy)