When Craig Cmehil first posted the SAP Hana Code Jam in Newtown Square, I immediately signed up. I am glad I did. I have spent time in SAP Hana on the Cloud Share, and I was able to create Analytic, Attribute and Calculated Views. I was able to connect it to BusinessObjects Explorer and Analysis Office. But why code on SAP Hana? This is the reason I attended.
It was a “PowerPoint-less” day without slides. SQL Script was reviewed, it was described as an extension to standard SQL. It allows you to pass multiple parameters, and allows for pushing logic into the database layer to get “closer to the data”.
Picture above is Thomas Jung discussing SAP Hana. The blue screen shows there were no PowerPoints today. Also in the picture is an intern with SAP IT.
Today we learned that CE functions are the preferred way to write logic in SQL Script as functions are highly optimized. Thomas said CE functions are easier to read. An attendee asked “where is SE11 in Hana?” – it is not there yet, but you can look at the catalog.
Thomas also demonstrated a nice SAP purchase order worklist using SAPUI5, which is HTML5 based, with no UI controlled flow on server. The UI is client side and makes REST-based calls to the server when needs data. His demo included over 1 million rows of purchase orders with a very fast response time. Included in this demo was a Google-like search experience.
Above is Thomas showing his purchase order worklist demo.
Most of the day was spent doing exercises on SAP Hana.
Above was a start from the first SQL Script exercise, developed by Rich Heilman.
Above is the second SQL script exercise. Can you tell if my script made it error free?
Above shows another SQL script exercise.
I also had time at the end of the day to use BusinessObjects Analysis Office 1.3 against Thomas’s SAP Hana Purchase Orders:
All in all, it was a great time. I wished I would have spent more time preparing by looking at the SQL Script guide that Craig sent everyone who signed up.
Links provided to us from Craig:
SAP HANA Modeling Guide (pdf)
Special thanks to Thomas Jung and Rich Heilman for always being there when we had questions. I also want to thank Dirk Pluschke (sp?) of SAP IT, who sat next to me and helped me too.
Lastly thanks to Craig for organizing. He explained that Code Jam is SAP’s way of getting closer to the developers. It’s FREE and if it’s in your area I encourage you to attend.
If you missed this Code Jam I recommend Rich Heilman’s CD166 session at SAP TechEd.