Skip to Content
Author's profile photo Former Member

How to Migrate Attribute, Analytical & SQL script based Calculation views

As mentioned in the document SAP HANA Features that are Deprecated the Attribute views, Analytical views and SQL Script based Calculation views are now deprecated. SAP discourages from using them in new projects and suggests that you migrate them into the appropriate recommended alternatives mentioned in this blog.

This document aims to provide you with the steps to Migrate the earlier created views.

  1. 1. To launch the Migration tool you need to go to the Console View by accessing Windows -> Show View -> Quick View

QuickView.png

  1. 2. Select the system that you are working on to Migrate the views
  2. 3. Choose the option of type of view to Migrate. The xml based Analytical privileges to SQL is not mentioned in the above blog and hopefully be covered in another document.

MigrateOptions.png

When you click Next, you have to select the packages from where you need to migrate the objects and also select the target packages where the new migrated objects need to be available.

Here you have 2 additional features.

     1. Make hidden columns visible – helps you make sure that the columns that you have added as end output to the views and later chose to make as “Hidden” in the Semantics layer can be exposed and made available in the target objects  


CopynMigrate.png

  2. Copy & Migrate – helps you to make sure that your original objects remain in the source package. If you do not choose this option you will loose your original object as it will be replaced by the migrated object – calculation views in place of attribute and analytical views & table functions in place .

The Migrated – table function for instance cannot be edited and so it is advisable to choose to make Copy & Migrate option while carrying out this step.


SelectTargetPackage.png

PLEASE NOTE: the Migrate function with Copy & Migrate works for the SQL Script based Calculation views, but not for the Attribute/Analytical views.

When you choose Copy & Migrate -> there should be a sub-drop down allowing to choose the Target package to which the Migration has to be completed.

When you click Finish – the migration will be completed successfully.

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      what is difference between COPY and Migrate...

      Author's profile photo Former Member
      Former Member

      Thanks Ranjith for the pictorial depiction of the migration tool.

      I tried it with a manual copy and move here: Scripted Vs Table Function and now would try to use the migration tool to see if it gives me apples to apples comparison.
      An Interesting thing would be to see how the graphical view passes the inputs to the table function if it has parameters.

      Reg
      Debanshu

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Will test and let you know. If you have any inputs please do share as well.

      Author's profile photo Singh Sardar
      Singh Sardar

      Hello Debanshu,

      Did you got chance to explore, if yes do let us know the pros and corns.

       

      Thanks

      Author's profile photo Alexander Keshishian
      Alexander Keshishian

      Hi Experts,

      hope this SAP note could be usefull https://launchpad.support.sap.com/#/notes/2465027 and a how-to document https://help.sap.com/doc/0633b7ab2ead4437bcc0c6ceb315b8ee/2.0.00/en-US/SAP_HANA_InformationView_Migration.pdf.

      Regards,

      Alex.

      Author's profile photo Rajesh Mutharaju
      Rajesh Mutharaju

      Hi Alex,

       

      seems like the PDF link is broken, can you please share the latest link.

      Thanks,