Hi All
Optimizations can be added at different levels: database, connectivity, universe, and report. Improvements and additional tunings can be done during
the whole lifecycle of the solution with a minimal or even null impact on the final user workflows.
For SAP HANA universe to utilize in-memory technology, modifying few key parameters in the relational connection and data foundation
we can optimize performances by increasing processing speed.
To configure an HANA universe is in the relational connection. Double click the HANA.cnx connection and edit, enter the appropriate credentials for the HANA database is entered.
enables the system to make fewer trips to retrieve the full data sets.
View the properties for the data foundation à click properties à click the handle to re-size the window
à View the parameters for the data foundation à Click parameters
This makes the query faster and requires less memory from the client tools. Set the parameters to YES, save the changes.
It’s applicable both on tables and information models building a universe on HANA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
9 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |