HANA-Optimized Data Modeling: InfoCubes.In the picture below, you can see BW on HANA architecture where all the key activities of BW are HANA optimized: SAP HANA is responsible to perform key tasks related to Data Warehousing delivering excellent performance while performing analytical reporting. When SAP BW is powered by HANA, all the tasks are performed using HANA database optimized techniques. This cuts down on data movement, making it possible to execute these activities much faster with BW on HANA. And, as mentioned earlier, HANA is faster because data is processed in memory, so there are no batching-delays.Īctivities like the activation step for DataStore Objects, or DSOs, and certain types of transformations are functionally the same on HANA as on other databases, but the actual processing has been moved into HANA rather than happening on the BW application server as it does with other databases. Instead of two separate databases, the HANA database handles both transaction Processing (OLTP) and Analytics Processing (OLAP). Now the aggregations are done at the HANA layer which makes administration much simpler. Due to the aggregation limitations of SAP BW, you could not pull data at different granularity levels. Each application had to be monitored and optimized individually, so performance tuning was also time-consuming. Even the simplest structural change could take 2-12 months. Enhancements and upgrades were time-consuming and often ran into compatibility problems. Data was moved to the warehouse in batches, preventing real-time reporting. Lack of real-time reporting capability.Other challenges of running SAP BW with third-party databases included: You had to stage data and use INFO-Cubes for aggregations and reporting. This required administering the SAP ERP system, an OLTP database, and a separate database for the INFO-Cubes needed for staging, aggregations, and reporting. Before HANA, running SAP BW on Oracle or another database was extremely complex. Let’s take a look at how SAP BW powered by HANA is different from the previous generation.
#Sap hana studio 2 plus
Plus the new UI is more intuitive and user-friendly Drawbacks to Pre-HANA BW This next-generation tool integrates with other SAP and third-party solutions and also allows you to process unstructured, geospatial, and Hadoop-based data. This allows for faster processing, improved data load performance, optimized query processing, and additional reporting features. Complexity is reduced because transformations and DSOs are now in the HANA environment. SAP BW combines DW capabilities like data integration and modeling with HANA’s in-memory processing to increase speed and data modeling capabilities. When you run SAP Business Warehouse (BW) on HANA, data is consumed in a data warehouse (DW). OK, let’s go back a bit and look at how SAP HANA BW evolved… We have a great blog on this called The ABAP Developer Road Map to SAP HANA, it is definitely worth a read – especially if your a developer. When correctly implemented, SAP HANA conveys outstanding results and performance, analytic intelligence, integration capabilities, data processing, and improved ROIs of the SAP landscape with swift time-to-value.
#Sap hana studio 2 code
The BW/4HANA code can only run on SAP HANA as it is interwoven with SAP HANA engines and libraries.īefore we dive in, it would be a good idea to understand what HANA is. Please note this is SAP BW running on a HANA Database, this is not BW/4HANA, which is part of the evolution of BW that is completely optimized and tailored to SAP HANA. SAP BW on HANA (BWoH) runs on the HANA database and therefore it is simpler and faster.
You can reach him at Business Warehouse (BW) powered by HANA also known as BW on HANA (BWoH) is SAP’s data modeling, warehousing, and reporting tool built on the HANA database. ITP is an Appian and Pegasystems iBPM Low-code and RPA Value Added Service Partner. Anthony has over 20 years of experience in SAP business process analysis and SAP systems integration.
ITP offers comprehensive planning, resource allocation, implementation, upgrade, and training assistance to companies.
Anthony Cecchini is the President and CTO of Information Technology Partners (ITP), an ERP technology consulting company headquartered now in Virginia, with offices in Vienna.