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.
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.
Well explained Scott!
I used your tip in one of my scripted calc view 🙂
Cheers,
Rabie
Thanks Rabie, great to hear it was helpfull!
Definitely Helpful 🙂