SAP is moving paces ahead in the area of technology. As part of their offering SAP BSOH (SAP Business Suite on HANA), they have been providing SAP ERP running on HANA. We have been hearing a quite lot about HANA, and what it can do to your data etc.., but checking out SAP HANA Live, we have decided to take it for a ride.
In the traditional space, we had two spaces in the IT infrastructure OLAP and OLTP. Please read http://datawarehouse4u.info/OLTP-vs-OLAP.html for more info
HANA has the wonderful feature of in-memory computing. Technically it puts all your data in memory, so that it can process faster and also will allow you to bring out analytics. That technically means HANA database can work as an OLAP and OLTP Engine at the same time.
This wonderful feature will also mean that we can skip the shady part of BW and run my analytics on the same HANA DB. Also with a few SAP HANA Content package (SAP HANA Live), there were some views which bring data from your SAP Instance.
We had made this setup of ECC 6.0 EHP7 running with HANA Database.
Some transactions later here here is some data reports from SAP Lumira. All the reports are online and live. Need not worry about your ETL scripts schedules etc…
There are many views that are available with SAP HANA Live, that can be used and analyzed. Screenshot of SAP HANA Live Browser, which can be used to visualize further.