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.

GENERAL INFORMATION

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

Decision Tables:

Using Decision Tables — with update values | SAP HANA (Update the database)  

                    Using Decision Tables — with return values only | SAP HANA (Simulation)

Text Analysis:

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

ADMINISTRATION

Table Partitioning: Pg 133 (Section 2.6.8) of SAP HANA Administration Guide. How to do it? Pg 145 (Section 2.6.8.5.1) of SAP HANA Administration Guide.

Hope it helps!