Skip to Content
Technical Articles

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

 

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
2 Comments
You must be Logged on to comment or reply to a post.