HANA pros and cons in BI
October 16, 2019

HANA pros and cons in BI

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Software Version

SAP HANA, standard edition

Overall Satisfaction with SAP HANA

In my company I'm working in the SAP BW area. At the moment, I'm working on SAP HANA in a BW 7.5 on Hana per data warehouse and planning for a food company. We're working with Sap Hana to integrate the data from other systems (as actual data) and we've done a model of planning for P&L.
  • Sap Hana is very well for the "in memory" base, for performance and saving data in columns instead of rows.
  • Very helpful with the use of calculation view to develop the final solution and simplify the list of objects.
  • Developed directly on Hana Database, with the use of new objects such as calculation view, store procedures and several new objects.
  • Planning function and planning sequence, more new functionalities "standard" to allocation, for example.
  • Improve performance of analysis for office as the frontend.
  • Simplify the use of execution plan, plan view, and similar.
  • New projects for our clients are interesting to improve performance.
  • Positive impact on the use of BI and analysis for office.
  • Negative performance regarding the use of memory.
I'm working with SAP products only.
Hana has shown that it can improve performance regarding data loading, data manipulation, and enrichment.
In my opinion, it has to improve in terms of frontend performance and better management of backend memory in some cases

Do you think SAP HANA Cloud delivers good value for the price?


Are you happy with SAP HANA Cloud's feature set?


Did SAP HANA Cloud live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of SAP HANA Cloud go as expected?


Would you buy SAP HANA Cloud again?


Hana is well suited for scenarios such as BI for manager data or enriching the data, and with objects as a calculation view. The developer can develop flow without ABAP or transformation (TRFN) but only use "virtual" data on the fly mode to avoid duplicated data.


IT Consultant for SAP BW