Skip to Content

Introduction

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.

Creating view

This picture shows some modeler views we created, all these views are based on the tables in schema “FURNITURE”.

/wp-content/uploads/2014/06/0_470040.png

Now, all the views have created completely and could be accessed directly.

/wp-content/uploads/2014/06/1_470041.png

/wp-content/uploads/2014/06/2_470066.png

Export views

As the left picture shows, choose File-> Export option, and then choose the Developer Mode of SAP HANA Content in the dialog box.

/wp-content/uploads/2014/06/3_470067.png

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.

/wp-content/uploads/2014/06/4_470068.png
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.

/wp-content/uploads/2014/06/5_470069.png

Import views

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.

/wp-content/uploads/2014/06/6_470070.png

After we choose the folder location, a files tree will be displayed and we could choose the views to be imported.

/wp-content/uploads/2014/06/7_470071.png

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.

/wp-content/uploads/2014/06/9_470072.png

/wp-content/uploads/2014/06/10_470073.png

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply