E_BW4HANA214 Questions and Answers

To move a large amount of historical data needs to be read occasionally in SAP BW Queries

To improve the qery performance of an SAPBW Query for aggregated year-to-date values

To reduce the TCO bases on the implementation of the Active/ Non-Active Data Concept

To create an offline archive for transactional data to ensure legal requirements are fulfilled

Model an Open ODS View of source type "DataSource (BW)"which refers to the SAP ABAP CDS U View

Model an Open View of source type "Dattabase Table or View" which refers to the SAP ABAP CDS U View.

Model a Composite Provide which directly consumes the SAO ABAP CDS View.

Model a Composite Provider which consumes an SAP HANA Calculation View which refers to the SAP ABAP CDS View.

Virtual InfoProviders for Planning are still allowed.

New InfoCubes can be created after getting approval by a whitelist.

All objects can be changed after getting approval by a whitelist.

The SAP BEx Analyzer is decommisioned.

Individual columns can be processed at the same time by different CPU cores

Individual columns can be transferred to an SAP HANA optimized row-based format for faster access

Individual columns are read-optimized by writing into a main store and a delta ^ store

Individual columns contain all of the information for ine record

List of all BW/4HANA incompatible SAP ERP DataSource

List of all BW/4HANA incompatible BW objects in the system

List of largest database table and additional sizing information

List of all missing SAP notes for installing the SAP BW/4HANA Transfer Cockpit

List of all BW/4HANA incompatible add-ons in the system

Execute Data Archiving Process (DAO)

Attribute Change Run

Trigger Delta Merge

Execute Analysis Process (APD)

Create an SAP HANA CDS View in SAP SS/4HANA which leverages a procedure to generate the delta based on the time stamp.

Create an ABAP CDS View in SAP S/4HANA which is enabled for extraction and generates the delta based on the time stamp.

Create an ABAP CDS View in SAP S/4HANA which is enabled for extraction and model the Change Delta Capture (CDC) logic based on the time stamp

Create a DataSource in SAP S/4HANA which leverages the generic delta based on the time stamp.

SDA is integrates into the SAP HANA Indexserver while you need to setup an additional SAP 1-1 HANA Data Provisioning server for SDI

SAP BW/4HANA DataSources of source system type "SAP HANA" can connect to SDA sources, U but NOT to SDI sources.

SDI provides options for data replication in real-time, while SDA does NOT provide this capability.

SAP BW/4HANA Open ODS View can be modelled on SDI sources, but NOT on U SDA sources.

Smart Data Access (SDA)

Remote Function Call (RFC)

Operational Data Provisioning (ODP)

Database Connection (DBCON)

SAP BW/4HANA receives a trigger from a Daemon in the source system. This event runs the Process Chain immediately

SAP BW/4HANA checks once a minute if a new record is generated in the

source system. If this check is successful, the Process Chain starts immediately

The concept is obsolete in SAP BW/4HANA. SAP recommends leveraging the new "PUSH Run Mode" for Streaming Process Chain instead

An SAP BW/4HANA Process Chain is scheduled as a periodic job with high frequency up to each minutes. The Process Chain runs accordingly