You can generate calculation views for queries in the SAP HANA database.
The following prerequisites must be met to generate an SAP HANA view:
Queries are compiled by the analytic manager into an optimized execution plan, meaning that most parts are executed in SAP HANA, and only a small part in the BW application server.
In many cases, the result set is complex and multidimensional. In some cases however, the query result can be displayed as a flat view and can be fully calculated in SAP HANA. For these queries, a calculation view can be generated from the BW system. This view can be consumed using SAP HANA native interfaces such as SQL.
BW Query Designer (BEx Query Designer and Query Designer in the BW modeling tools) remains the modeling tool, while the BW Analytic Manager compiles the execution plan, and the BW system stores the metadata and is used for the transport and the lifecycle of the data model.
The texts of the query elements are always added in the logon language of the user. With key figures, the technical name in the SAP HANA view is the same as the UID, if no technical name has been specified. You can display the UID in the UID Query Designer: . You can display the technical name in the UID Query Designer: .
If your change the query in the BW modeling tools, the associated SAP HANA view is automatically updated. However, the global elements are not updated. If global elements have been changed, these elements will only be changed in the query, once the query has been activated again. The associated SAP HANA view will also be updated.