Support Matrix for Importing Data from SAP NetWeaver BW and SAP BW/4HANA

See what SAP NetWeaver BW and SAP BW/4HANA data-import 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 Data Import)

Notes

InfoProvider Dimension

No

The organizational structure of InfoProvider Dimension is not supported.

Characteristics

Yes

 

Key Figures

Yes

 

Free Characteristics

Yes

 

Restricted Key Figures

Yes

 

Calculated Key Figures

Yes

 

Display Attributes

Restriction

A BW attribute can be acquired into SAP Analytics Cloud as a "Property" of a Perspective column.

This requires the end user to manually change the representing attribute column in SAP Analytics Cloud as a Property classification.

Navigational Attributes

Restriction

A BW attribute can be acquired into SAP Analytics Cloud as a "Property" of a Perspective column.

This requires the end user to manually change the representing attribute column in SAP Analytics Cloud as a Property classification.

BEx Query Filter (defined under Characteristic Restrictions)

Yes

 

BEx Query Filter (defined under Default Values)

Yes

 

Custom Key Figure Structure

Yes

 

Custom Characteristic Structure

Yes

 

Hierarchical Custom Key Figure Structure

No

 

Hierarchical Custom Characteristic Structure

No

 

Selection of elements of a custom structure in the report

No

 

Support for 2 structures from BEx Query

No

 

Compounded Characteristics

Yes

 

Support for Characteristic Data Type NUMC

Restriction

Characteristics members with type NUMC are interpreted as String type in SAP Analytics Cloud, and not as numbers.

Support for Characteristic Data Type CHAR

Yes

 

Support for Characteristic Data Type DATS

Restriction

Characteristics members with type DATS can be acquired in SAP Analytics Cloud. However, the data type must be manually set by the end user as type Date.

Support for Characteristic Data Type TIMS

No

 

Support for Key Figures Data Type Amount / Quantity

Yes

 

Support for Key Figures Data Type DATS

No

 

Support for Key Figures Data Type TIMS

No

 

Information about configured Filters in the BEx Query

No

 

BEx Text Elements

No

 

Support for Conversion EXIT

No

 

Variables in BEx Query

SAP Analytics Cloud

(BW Data Import)

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

 

Key Date Variable

Yes

 

Text Variables

Yes

 

Variable Processing Type: User Entry / Default Value

Yes

 

Variable Processing Type: Replacement Path

Restriction

Restriction: For the variable processing type Replacement Path, variables with replacements from the query result are not supported, when the query again (first query) has variables that are configured as ready for input.

Variable Processing Type: Customer / SAP Exits

No

 

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

 

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

No

 

Support for cascading Hierarchy / Hierarchy Node Variable dependency

Yes

 

Support for cascading variables for Compounded Characteristics

No

 

Support for Variable Default Values

Yes

 

Support for BW Variable Variants

No

 

Support for BW Variable Personalization

No

 

Copy / Paste variable values from clipboard

No

 

Filling variable values from Microsoft Excel File

No

 

Merge / Unmerge Variables

No

 

Defining Variable Sequence in the report

No

 

Variable Sequence based on BEx Query Designer

Yes

 

Support for validating values before executing the report

No

 

Read Mode for list of values (master data, InfoCube)

No

 

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

 

List of Values : Sort values based on Description Values

No

 

BEx Query Functionality

SAP Analytics Cloud

(BW Data Import)

Notes

Currency / Unit Conversion (defined in BEx Query)

Yes

 

Currency / Unit Conversion (defined at the client level)

No

 

Condition in Rows (from BEx Query)

Restriction

Conditions along the Rows only.

It is possible to acquire BW data results based upon a BEx condition rule at the time of data import. The condition is determined by the underlying rules defined in the BEx query, and the "structure of the query".

Once the BW dataset is acquired to SAP Analytics Cloud, the OLAP engine is no longer involved. Hence, the user must be careful in dealing with the BW dataset in SAP Analytics Cloud, as the context of the BEx condition support is no longer applied.

Thus, the support of conditions may not behave as you would expect compared to an OLAP BI client.

Condition in Columns (from BEx Query)

No

 

Conditions for fixed set of characteristics (from BEx Query)

Restriction

Conditions along the Rows only.

It is possible to acquire BW data results based upon a BEx condition rule at the time of data import. The condition is determined by the underlying rules defined in the BEx query, and the "structure of the query".

Once the BW dataset is acquired to SAP Analytics Cloud, the OLAP engine is no longer involved. Hence, the user must be careful in dealing with the BW dataset in SAP Analytics Cloud, as the context of the BEx condition support is no longer applied.

Thus, the support of conditions may not behave as you would expect compared to an OLAP BI client.

Condition for independent characteristics (from BEx Query)

Restriction

Conditions along the Rows only.

It is possible to acquire BW data results based upon a BEx condition rule at the time of data import. The condition is determined by the underlying rules defined in the BEx query, and the "structure of the query".

Once the BW dataset is acquired to SAP Analytics Cloud, the OLAP engine is no longer involved. Hence, the user must be careful in dealing with the BW dataset in SAP Analytics Cloud, as the context of the BEx condition support is no longer applied.

Thus, the support of conditions may not behave as you would expect compared to an OLAP BI client.

Defining Conditions in the report

No

 

Exceptions (defined in BEx Query)

No

 

Constant Selection

No

 

Cell Editor Calculation

No

 

Local calculations (defined in BEx Query)

No

 

Exception Aggregation

No

 

Zero Suppression

Restriction

Zero suppression defined along the columns is not supported.

Zero suppression defined along the rows is applied at time of data import.

Once data is imported into SAP Analytics Cloud, Zero Suppression is no longer applied as the BW OLAP Engine is not involved at this point. Re-calculation of Zero Suppression based on selection of Dimensions and Measures in an SAP Analytics Cloud cross-table or visualization is not possible.

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

No

 

Read Mode for characteristics in InfoObject

No

 

Display Settings in BEx Query

SAP Analytics Cloud

(BW Data Import)

Notes

Scaling Factor

No

 

Reverse Sign (+/-)

Yes

 

Number of Decimals

No

 

Hide / Show the Element

No

 

Sort Characteristics

No

 

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

Yes

 

Result Rows (Show, Suppress)

No

 

Placement of subtotal (above / below nodes)

No

 

SAP Analytics Cloud Hierarchical Functionality

SAP Analytics Cloud

(BW Data Import)

Notes

Support for Hierarchies with Linked Nodes

No

 

Support for time-dependent Hierarchies

No

 

Support for time-dependent Hierarchy Structures

No

 

Support for Hierarchies with Temp Join

No

 

Show specific Hierarchy Levels

No

 

Skip levels of a hierarchy

No

 

Show Leaf Members only

No

 

Ranking Data along a hierarchy

No

 

Expand to Level Functionality (BEx Query Designer)

No

 

Expand to Level Functionality (defined in the BI client)

No

 

Compact Axis in the Rows (Display as hierarchy)

No

 

Compact Axis in the Columns (Display as hierarchy)

No

 

Hierarchical Charting

Yes

 

Exchange of hierarchies

No

 

Other Integration Topics

SAP Analytics Cloud

(BW Data Import)

Notes

Scheduling of a Story

No

 

Publication of a Story (= Broadcasting)

No

 

Support for Report Report Interface as Sender

No

 

Support for Report Report Interface as Receiver

No