SAP BW Vs BW On HANA/SAP BW/4HANA

[former_member188080]

 

As SAP BW Journey is evolving there are many new features are added in SAP BW on HANA until BW7.5 version. With SAP BW/4HANA entire SAP BW is kind of getting modernised.

 

Lot of older classical BW version limitations are overcome in latest SAP BW/4HANA version.

In below table i tried summarising in some of those aspects where SAP BW/4HANA is really tailored /performance efficient and coming out as superior version.

With SAP ECC migrating to SAP S4 HANA from Business warehouse perspective customer will look forward towards BW/4HANA version for Next gen reporting ETL and  SAP reporting Tool.

 

	Classical BW	BW on HANA/BW/4HANA
Code Push down to HANA	Data to code. Transfer of all data to application level	Code to Data Porcessing of data at Database level, hence less data transfer to application layer. Mostly calculated results are transferred to application layer
Infoobjects	Mandtaory for reporting	Objects like Open ODS view and ADSO can still work without Infoobjects
	2 Billion restrictions on master data values	No such restrictions in BW/4HANA
Extra long text in Charaters	60	1333
Data store Objects Classical	Activation step is needed	Activation step time is reduced almost by 60-70%
		New tables added with /BIC/A<DSO Tech name>70 and 80
	Key 16 and Char 749 Max	Key 16 and Char 749 Max
Infocube	Min 6 to Maximum 18 Tables	2 Tables only
	Fact Table,Compressed Fact table,Standarad dimension package, Standard dimension Time and Unit,Customer dimension 1-9 and customer dimension 10-13 (A-D)	Fact table , Standard Dimension Package table
	248 Charateristics and 233 key figures	248 Charateristics and 233 key figures
		Comrpression creates 4 Partitions as follows 1. Partition 1 - Compressed Requests 2. Partition 2 - Marker updates for Inventory data 3. Partition 3- Historical movements of inventory data 4. Partition 4 - Non compressed requests
		Improvement in reporting run time Improvement in load runtimes Low memory requirements
Conversions of Infocubes		RSMIGRHANADB,Program - RSDRI_CONVERT_CUBE _TO_INMEMORY
Semantics		Can be migrated using RSMIGRAHANADB
Multiprovider		Can be replaced by Composite providers
Infosets	Longer runtimes	Still supporting but longer runtimes. BW/4HANA does not support Infosets
Infosources	Based on application components	Based on Infoareas
Infoareas		Infoobject catalogue no longer appear in BW/4HANA
Transformation rules		Below properties are not used any more 1. ABAP Routines of any type 2.Rule groups 3.Customer specific formulas 4. BW queries as a source object
ABAP routines	ABAP runtime is supported. SAP HANA execution is Off	HANA runtime is supported. AMDP (SAP HANA execution supported)
Process chains		Following process types are no longer required 1. Delete/Create Index 2. Set up Database statistics 3. Update BW Accelerator Indices 4. Roll up aggregates 5. Fill up aggregates 6.Adjust aggregates via change run 7. Update BO Explorer properties
Delta merge		Applicable in SAP HANA database
Old /New objects	Multiprovider Infoset Virtual provider	Composite provider New
	Virtual provider	Transient provider Open ODS View
	Infoobject	Infoobject
	Infocube Classic Datastore objects PSA Table	Hybridprovider Datastore objects advanced