When activating BW objects that you want to create, you can generate SAP HANA views with the same structures.
This enables you to create scenarios where data, which is modeled in the BW system, is merged with data modeled in SAP HANA with SAP HANA tools (mixed scenarios).
The following objects are supported here: SAP HANA-optimized InfoCubes, DataStore objects, InfoObjects, queries as InfoProviders, CompositeProviders, local CompositeProviders in the BW Workspace and queries.
When SAP HANA views are generated, BW data is published to SAP HANA. These SAP HANA views point directly to data and tables that are managed by the BW. BW data can therefore be consumed directly in SAP HANA. This also provides a clear interface between the schema managed by the BW and an area outside the BWs, which is managed by other tools or by another user group. This interface makes clear where the services in the BW system end, and where the manual enhancements or enhancements via third-party tools begin. It is not possible to change generated SAP HANA views manually. The SAP HANA views generated by BW can be overwritten at any time by the system, meaning that any manual changes would be lost.
You can create more SAP HANA views on these generated views however. These will then be stored in another Content package.
Generating SAP HANA views from the BW system enables you to generate SAP HANA views without using the SAP HANA Modeler. You can thus access BW data via SQL front ends. All applications that can read SAP HANA views can process the data (for example, SAP BusinessObjects Analysis, edition for Microsoft Office, SAP BusinessObjects Web Intelligence, SAP BusinessObjects Explorer, SAP Lumira and BI Clients from third-party providers).
When a query is executed on the SAP HANA view, the data is requested directly from SAP HANA, without the BW system being addressed.
Generation of SAP HANA views from the BW system has been implemented as an interface for standalone data marts. This means that these SAP HANA views are only suitable for special scenarios.
These SAP HANA views are part of the BW InfoProvider lifecycle. They are transported with the corresponding BW objects. The target system should have an SAP HANA database. If it does not, the property that the object has an SAP HANA view will be lost.
When a BW object is activated with the SAP HANA view, all the dependent SAP HANA views are also activated. If an error occurs with an SAP HANA view that you created, this only leads to a warning and the BW object is activated.
The analysis authorizations in SAP HANA are created during activation of the BW objects and compared with the analysis authorizations in BW.
Transaction RS2HANA_ADMIN enables you to manage SAP HANA views from BW objects. Here you see an overview of all BW objects with an external SAP HANA view and various administration and check functions. You can call this transaction as follows: .
Not all BW objects properties can be added to the generated SAP HANA view. The following restrictions apply: