Create
Learn
Share

Hana Modeling

rename
losfer2001's version from 2015-10-08 04:47

Modeling checklist

Question Answer
Intensive scenariosWrite or Read
Real time data accesssupport of table type
authorizationanalytic, calculation, attrib views
application clientdifferent clients
functionalityalgorithm, currency, unión
performancedifferent views
memorize

Hana Engine

Join Engine
Calculation Engine
OLAP Engine

Decisión Tree

Question Answer
Star schema or aggregationAnalytic View
Joins and calculated expressionsAttribute View
Graph Calc ViewGraph Calc View
memorize

Join Types

Question Answer
innerfacts w/matching dimensions
left outerall facts w or wo dimensión
right outerall dimensions whether or not fact
referentialmatching only when referential integrity
texleft outer join w multilanguage table
temporalreferntial join validity period
stardata organized as star
memorize