Importing SAP BW∕4HANA Models
You can import existing analytic queries from SAP BW∕4HANA into SAP Datasphere in order to build new models on top of them or enhance them.
For information on supported objects and functions, see SAP Note 2932647
.
With the import, objects are generated in the Data Builder and optionally in the Business Builder as well. Data access to SAP BW∕4HANA is realized through these objects. The data is retrieved directly from the SAP BW∕4HANA system via remote tables.
You can then use these models as they are or enhance the data in SAP Datasphere on each level of your model - for example by adding master data to a view of type dimension.
The graphic shows the process flow for importing queries:
Prerequisites
You have an SAP BW∕4HANA system installed.
In your SAP BW∕4HANA system, you need to release the analytic queries for transferring into SAP Datasphere. For more information, see: Releasing Analytic Queries for Use in SAP Datasphere.
In SAP Datasphere, you have created a connection of type SAP BW/4HANA Model Transfer to connect to your SAP BW∕4HANA system. For more information, see SAP BW∕4HANA Model Transfer Connections.
Procedure
-
In the side navigation area, click Business Builder. Select a space if necessary.
-
Choose .
-
In the Model Transfer Wizard, search for and select the SAP BW∕4HANA connection that you would like to use. Choose Next. The system will show you all available analytic queries.
-
Use the Create Business Builder Objects setting to control which objects to create:
-
Business Entities and Consumption Models [default] - Create all possible Data Builder and Business Builder objects.
-
Business Entities Only - Create Data Builder objects and Business Builder business entities.
-
None - Create only Data Builder objects. Queries are imported as SAP Datasphere analytic models, which can be consumed directly in SAP Analytics Cloud. The analytic model inherits all the properties of the analytic query, like associations, global filter, restricted and calculated measure etc..
-
-
Select the analytic query that you would like to transfer. In the pane on the right, you will see the list of objects which will be generated in the Business Builder and in the Data Builder. The Import Status tells you if the objects already exist and will be overwritten or if they are new.
-
[optional] To import the analysis authorizations associated with the data in the query, click the Import Permissions button, and then click OK.
Additional objects will be added to the list of objects to be imported on the Data Builder/Data Access Controls tab to create the data access control and apply it to the fact. -
Choose Import.
