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