SAP HANA Advanced Modeling Features – Learnings of a few
“I seem to have been only like a boy playing on the seashore, and diverting myself in now and then finding a smoother pebble or a prettier shell than ordinary, whilst the great ocean of truth lay all undiscovered before me.” – Isaac Newton Isn’t this the case for many people when it comes to ‘HANA’! While I am trying like everyone to explore and experience every new of THE HANA platform, i found myself lost to guide a few like me.
In the following post, I try to put my findings on the new and very interesting topics on SAP HANA which involves no (or lmitied) coding but rich modeling to achieve answers to crtitical business problems. The contributions noted below are from fellow experts on sCN and I appreciate and thank each to enable us to this information. Compelte credit to the contributors!
Note: The information below is compiled with reference to HANA SP07. The list below may seem like notes (because they actually are, when I was clearing my doubts on these topics!) and should not be considered exhaustive.
New & Useful features in HANA SP07
HANA SP07 – Modeling/Administration/Installation/Developer Guides: SAP HANA Platform – SAP Help Portal Page
HANA Academy: SAP HANA Academy | SAP HANA
openSAP Courses: Courses
SAP HANA Community (Customer Stories/Development Resources/Forum/News/Events): Learn | SAP HANA
MODELING/ADVANCED MODELING TOPICS
Star Join in a Calculation View: HANA SP07 – STAR JOIN
Best practices in Calculation View:
Effective Query pruning using Constant Column in UNION node
Building Advanced Data Models in SAP HANA
Temporal Join: SAP HANA Temporal Joins
Using Decision Tables — with update values | SAP HANA (Update the database)
Using Decision Tables — with return values only | SAP HANA (Simulation)
Text Analysis: Overview | SAP HANA
Text Analysis: Configurations: Custom | SAP HANA
Text Analysis: Configurations: LINGAnalysis | SAP HANA
Using SAP HANA Variables & Input Parameters in SAP BI 4.0: Link
Time travel using History tables in SAP HANA: When I traveled through time using SAP HANA!!
SAP HANA Local/Global Temporary Tables: SAP HANA Temporary Tables
Declarative & Imperative difference: What is the difference between declarative and imperative programming
Geo-spatial processing in SAP HANA:
Experiences with SAP HANA Geo-Spatial Features – Part 1
Experiences with SAP HANA Geo-Spatial Features – Part 2
Table Partitioning: Pg 133 (Section 2.6.8) of SAP HANA Administration Guide. How to do it? Pg 145 (Section 18.104.22.168.1) of SAP HANA Administration Guide.
Hope it helps!
Thanks for this!