You can generate calculation views for local CompositeProviders in the SAP HANA database from BW Workspace.
Procedure
- You are in BW Workspace Designer.
- You can generate an SAP HANA view for an existing CompositeProvider by going to the CompositeProvider tab under My Workspace. Select your CompositeProvider and choose Change. Choose Create Queries. Set the External SAP HANA View for Reporting flag.
- If you want to create a new CompositeProvider and generate an SAP HANA view for this CompositeProvider, proceed as follows: Creating CompositeProviders in BW Workspace Designer
In the Create Queries step, set the External SAP HANA View for Reporting flag.
- When the CompositeProvider is activated, an SAP HANA view corresponding to the structure of the object is generated on the SAP HANA database.