Skip to Content
Author's profile photo Former Member

HANA Tips & Tricks: issue #1a – Addendum: Importing Columns for Scripted Calculation Views

Last weeks post by Roland Bouman mentions a cool program he built, to easily generate column definitions in a scripted calculation view.

Creating columns with matching names and datatypes manually can obviously be tedious and error prone.

Later I remembered that such a standard option exists in HANA Studio as of SPS9 “import columns from”.

After selecting the script node in the editor, select the drop down box from output area in the top right.

Add_column_from.png

This could be a nice time-saver, instead of entering columns manually.

If you enjoyed this, I would definitely recommend The what’s new series, like: http://www.slideshare.net/SAPTechnology/sap-hana-sps-09-hana-modeling

They are filled with handy tips like this.

Assigned Tags

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

      Well explained Scott!

      I used your tip in one of my scripted calc view 🙂

      Cheers,

      Rabie

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

      Thanks Rabie, great to hear it was helpfull!

      Author's profile photo Gowthami Bhogireddy
      Gowthami Bhogireddy

      Definitely Helpful 🙂