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
Review Source

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.
The customer has benefited from this capacity, even if it happens that with the amount of data required, a very low level of detail may affect performance. Performance improves when the right granularity is found.
It is always very important to have the opportunity and the possibility to integrate different external systems or languages other than the SAP based ones.
In my current experience, there is not much influence as Sap Hana was used to create a P&L model with sales, cogs, logistic, cost centers and CAPEX. Also, many things were done custom.
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 delivers good value for the price?

Yes

Are you happy with SAP HANA's feature set?

Yes

Did SAP HANA live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of SAP HANA go as expected?

Yes

Would you buy SAP HANA again?

Yes

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.

Using SAP HANA

IT Consultant for SAP BW