SAP NW BW 7.3, powered by SAP HANA - How does the InfoCube/DSO data gets stored?

87 Views

Hi HANAians,

Its good to see so many people discussing about SAP HANA and BW on HANA. I am late to enter this forum, since I was on experiencehana.com 😊

Some straight questions -

1. Once BW is on HANA, how does the data in InfoProviders (InfoCube/DSO) gets stored in the HANA DB - Columnar or Row. Or is it the 'internal intelligence' of HANA that decides how to store the data. If so, HOW (on what parameters) does it decide? In one of the documents, it was mentioned that only Analytic Views created in HANA Studio in turn creates and stores data in columns.

2. We have massive parallel processing available via multi-core processors. How do I leverage the same with my existing ABAP/Coding in BW? Native SQL (pushing calculations onto Database Layer) and Asynchornous RFCs (Parallelism) are some of the ways. Any other methods? And if I need to leverage, I will need to change my ABAP. This defeats the 'non-destructive' glamour of BW on HANA.

3. With BW on HANA we do not utilize one of the USP's of HANA which is real-time analysis. Unless, you have enhanced your datasource earlier for real-time extraction. Which means only in-memory (and some areas of modeling like compression is no more required, etc.) is the advantage here. Any thoughts?

4. HOW does HANA compress the source data to achieve compression ratios of ~ 5 times. is it only the columnar storage that leads to such massive compression of data?

Appreciate your thoughts on the above.

Thank you.

Regards, Kunal Gandhi