SAP NetWeaver BW, Powered by SAP HANA

December 07, 2011

SAP HANA is a high-performance analytic appliance that provides SAP software components optimized on hardware from SAP’s leading hardware partners.


HANA’s in-memory computing engine enables organizations to effectively analyze business operations based on very large volumes of detailed real-time data, without affecting backend enterprise applications or databases.


There is great deal of confusion on SAP HANA and its impact on SAP products. The confusion is more on SAP BW, Since this is an area where rapid changes are happening due to business objects and SAP HANA.

By the second half of 2011, SAP customers all over the world can start  to migrate to HANA as the database running  SAP BW  using the SAP R3Load tools. 


SAP says it is committed to the data warehouse deployed by 15,000 of SAP businesswarehouse.


It is just matter of time that, the code of every SAP application will be refactored to run on in-memory technology, including and especially the Business Suite and SMB applications.


That is not a reality now. While SAP has Business One and Business All-in-One running directly on the HANA database in its labs, as SAP CTO Vishal Sikka noted at the event in Boston, none of HANA’s pilot or ramp-up customers is running it as the database under the transactional applications.


Instead, data in the CRM system that is running on DB2, for instance, is replicated into HANA using the Sybase replication server. SAP says this can be done for customers on releases as far back as 4.6c.


What was most clear at SAP’s recent events is " in-memory technology is going to be the core of SAP's future direction. As in-memory technology is adopted, SAP claims, there are fewer moving parts between delivering the data in that SAP back-end to end-users with cost savings on hardware and DB Administration and significant number of manhours.


For example, HANA Cash and Liquidity management will allow organizations to essentially turn off the dunning functionality in the FI module.


SAP BW on HANA technology is first SAP's in-memory database application among SAP suite of applications. You no longer need to use Microsoft, IBM or Oracle database, you can replace them with SAP's HANA database and is more powerful and responsive than any other vendor's technology.

What  is SAP In-memory Technology?

SAP HANA Appliance


SAP NetWeaver BW, Powered by SAP HANA


SAP BW customers alll over the world are facing issues like report performance, flexibility or overnight schedules that run into the day etc. SAP 's HANA on BW is the solutions for all thsese problems.


SAP HANA can be added to an existing landscape, which may already include data sources and business intelligence software.

The SAP HANA database is an appliance that hosts in-memory computing engine, which leverages technologies such as columnar storage, massively parallel processing, and data compression. This allows organizations to explore large volume of data in real time.


SAP HANA Studio is a front end software which shall be installed on a diff hardware than HANA appliance. There are two main components of software 

Admin console

Information modeller



sap hana steps to load data



Two methods to load data SAP Landscape Transformation (SLT) replication and Data Services transformation.



SLT Replication







Using information modeler in SAP HANA Studio we can create analytic and calculation views in HANA, based on the data in underlying tables.



Using information design tool, we can build universe (UNX) that are stored in SAP Business Objects BI platform repository. Relational universes can be built directly on tables in HANA. 


SAP BI Tools


For analyzing HANA Data SAP offers SAP Business Intellegence BI suite of products.SAP crystal reports 2008 and SAP Crystal reports 2011 can connect to tables in HANA to create formatted reports.


SAPBusinessObjects Explorer 4.0 and SAP BusinessObjectsAnalysis edition for Microsoft Office V1.1 SP03, can connect to views in HANA to explore and analyze data. Microsoft Excel 2007 is also able to connect to views in HANA.


SAP BusinessObjects Web Intelligence 4.0, Crystal reports for enterprise 4.0, and Dashboards 4.0 use relational universes to connect to HANA to analyze data and create reports and visualizations. The universes can be based on views or tables in HANA.


SAP HANA and BW First Steps


1. First, install (or upgrade to) NetWeaver BW 7.3 SP05.

- Refer to SAP Note 1647785 "SAP NetWeaver 7.3 BW, powered by SAP HANA - Information"

- SAP Note 1644137 "Composite SAP Note: BW porting in SAP HANA DB, NW 7.30 SP06".


2. Follow the standard SAP migration process (Like any SAP product)


3. Check database tables, indexes, data dictionary. And run the usual export process using the normal NetWeaver BW 7.3 CD. This will give you a standard SAP export. 


4.Install SAP HANA 1.0 SP03 database first, which takes about an hour. It's a simple process and because SAP HANA runs on an appliance.


5. Run SAP installation media for SAP NetWeaver BW 7.3 on HANA and use  the export that we created before and choose go button. ( Approx 20 - 45 min).


6. Once this process is complete, the migration of what was on the export into SAP HANA happens and SAP application software installation onto the appliance completes.


I am impressed with SAP HANA technology. I am following the development of this concept closely since 2006 and I am positive that this product is now ready for the prime time and is going to be one of the BIG breakthorugh's in SAP technology. All early indications show that SAP HANA  can really solve all the BW users day to day pains. 


Rajesh-VeerapaneniRajesh Veerapaneni is a Co- Founder and Chief Architect of UNISIS Intl Inc(, A Global SAP Technology and Consulting firm. Raj is working in SAP space for 18 years and he is one of the leading SAP technologists in the world, still managing to work with SAP clients around the globe to design and implement complex, large-scale, highly available enterprise architectures.

Raj specializes in SAP SD / BI BOBJ and Portal space and has personally consulted to over 20 SAP clients including GM, International Paper, Chevron, Rexam, HP, Ilogistix, Wolseley, Abbott labs and many others.

Raj is Co-Author of "Managing E - Business Projects" in the year 2000, Raj was a keynote speaker in more than 250 seminars held around 30 cities. Raj published numerous articles in computer journals. Raj can be reached at