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 |
Thanks for sharing information..!
Perfect..!
Short and sweet briefing!
Thanks Kiran for sharing.
Is it correct to place "BW on HANA/BW/4HANA" on the same column??
BW on HANA and BW/4 are not the same system.
BW/4HANA vs. BW on HANA
https://www.sap.com/documents/2017/08/30aa5e11-cf7c-0010-82c7-eda71af511fa.html