26 Jul SAP BW on HANA
What is SAP BW?
SAP Business Warehouse is SAP’s strategic and efficient Enterprise Data Warehouse solution running on industry standard RDBMS (Relational Database Management System) and SAP’s HANA in-built memory DBMS (Database Management Systems). It delivers:
Business data is of vital importance for an organization’s improvement and competitiveness, because it helps optimize operations and enables the company to react fast to meet market standards and take advantage of market opportunities. SAP BW helps you integrate, transform, and consolidate relevant business data from productive SAP applications and external data sources.
SAP BW provides you with a high-performance infrastructure which helps you make powerful evaluations and interpretations of your business information. This helps the decision makers of the company make well-informed decisions and identify target-oriented activities based on the analyzed information.
What is SAP HANA?
SAP HANA is an in-memory RDBMS which is column-oriented. The architecture of this technology is designed to handle both high transaction rates and complex query processing on the same platform.
What is SAP HANA Architecture?
SAP HANA’s architecture is comprised of hardware, software and its processes in particular. Nowadays, only certified servers and operating systems are supported for productive usage of SAP HANA. The complete product consisting of hardware, operating system, SAP HANA, and all relevant tools is called an appliance.
Customers can choose among pre-defined packages when purchasing SAP HANA for production purposes. Servers can be deployed for scale-out, test, and development systems depending on the client’s requirements. SAP HANA’s approach to application development is strongly focused on hardware which is why it is so high performance.
The dimensioning of hardware, as well as the database innovations of SAP HANA live up to their potential especially when you deploy the software which was developed on this basis. Products such as SAP BW have been adapted for this purpose, and additionally, an entire portfolio of SAP HANA appliances arises.
SAP HANA is supported on Red Hat Enterprise Linux Servers. It was released for SAP HANA after the SUSE operating system. Only the SUSE Linux Enterprise Server for SAP Applications has been permitted so far for optimal operation.
New versions of the installed software packages are required for both operating systems if SAP HANA is to be deployed as of version 80. The list of the relevant changes can be found in SAP Note 2001528.
The tasks of SAP HANA are implemented through several processes. You can monitor both the resource utilization and possible error sources of these processes via the operating system or SAP HANA Studio.
Office Amsterdam > xadat.nl
Office London > xadat.co.uk
Office Malaga > xadat.es
Office Sofia > xadat.bg
What are the benefits of SAP HANA?
SAP HANA is a SAP database technology designed for very fast performance. SAP HANA achieves that by storing all data into the main memory. This makes processing huge amounts of data much more efficient than regular databases which first load the data from the HDD or SSD.
While traditional databases employ simple caching processes, SAP HANA provides a new functionality – the usage of the in-memory technology in combination with additional innovative software technologies. This includes:
- Column-based data handling
- Usage of complex compression and access operations
- Partitioning of database tables
Due to the performance characteristics and functionalities of SAP HANA, it leads to a significant acceleration in the corresponding applications where it is used.
What is SAP BW on SAP HANA?
SAP BW on SAP HANA combines the speed benefits of SAP HANA with the comprehensive functions of SAP BW. Reporting and loading processes are accelerated significantly.
At the time when SAP HANA was announced, businesses saw the potential of this technology, but the risk of implementing immature software was too high. At first SAP HANA was used in parallel, or side-by-side, to already existing systems. This continuously replicated the data from a slower database to the SAP BW on HANA database and allowed organizations to test the high performance data analysis of HANA.
Today, SAP HANA is a tried and tested software and is no longer integrated with the side-by-side approach. Companies that are looking for database performance have already replaced their old databases with SAP HANA.
Jim-Hagemann Snabe, one of the two chairmen of SAP SE until 2014 simply stated that SAP must become as simple as Apple and as fast as Google. SAP HANA contributes significantly to this goal, which is one of the reasons why so many companies choose to migrate SAP BW on SAP HANA.
What are the benefits of SAP BW on SAP HANA?
The most important advantage of SAP BW on SAP HANA is the high speed with which analyses and reports will be performed which is the result of the in-memory technology, the numerous software-related innovations, and the optimized hardware which come with HANA. For instance, in a few test projects, SAP BW reports were reported to be more than 30 times faster.
The execution time of a report will also be reduced from about a minute down to less than two seconds which allows for a significantly more frequent use of SAP BW reports. It also allows organizations to optimize existing business operations or design completely new process flows. For example, Yodobashi, a Japanese electronics goods retailer managed to reduce the calculation of incentive payments for customers from three days to two seconds allowing them to inform their customers at any time about information they request.
In addition to the significantly faster performance, SAP BW on HANA also makes data retention processes more efficient. The memory size of the database is reduced because of the column-based data storage technology of SAP HANA, and the powerful compression methods that are used.
The faster access to data and the other performance benefits of HANA make it possible for SAP BW data to no longer be provided in denormalized tables. A high performance report for SAP BW on SAP HANA is always guaranteed, irrelevant of how the data is provided.
How can Xadat Help you?
Implementing SAP BW on SAP HANA can be a difficult task. We can help you with all the preparation steps:
- Creating a homogenous system
- Cleanup of your current system
- Implementation of new and additional tools
Mondy Holten, SAP BI Consultant