Export and Import Modeler Views In SAP HANA
Modeler is often used in SAP HANA development, usually dozens even hundreds of modeler views are created in one project.
Just imagine in a very large project, developers take their own programming works in different environment and finally in the integration phrase, all these developed content should be deployed to the real production system. We need a way in which these modeler views could be easily exported and imported through instances. SAP HANA does provide this feature that realizes rapid migration of modeler views.
This blog describes how to import and export modeler views in SAP HANA.
This picture shows some modeler views we created, all these views are based on the tables in schema “FURNITURE”.
Now, all the views have created completely and could be accessed directly.
As the left picture shows, choose File-> Export option, and then choose the Developer Mode of SAP HANA Content in the dialog box.
Select the instance and modeler views to be exported, you could choose all the modeler views or certain view of this package by given the location.
After that, it generates a tree structured directory in the target folder. The format is “instance SID-> package name-> analyticviews/attributeviews/calculationviews/package_name.properties”. So far, we’ve successfully finish exporting.
Before exporting the views, we must ensure all the related tables have been migrated to the target instance and then we could grant related privilege to the user.
grant select on schema furniture to _sys_repo with grant option;
As the following pictures show, the procedure of importing is very similar with exporting.
After we choose the folder location, a files tree will be displayed and we could choose the views to be imported.
The imported view will display as a grey icon, which means it is not active. Right click the view and then choose validate and active, then it will be available.