Tutorial/Schema cheatsheet

From TempusServa wiki
Revision as of 01:59, 28 February 2014 by old>Admin (Created page with ' == Schema structure overview == * Table (one): ** Structure: The centre table * Dimensions (many) ** Structure: Related tables or groupable values ** OLAP: Columns/row "hea…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Schema structure overview

  • Table (one):
    • Structure: The centre table
  • Dimensions (many)
    • Structure: Related tables or groupable values
    • OLAP: Columns/row "headers" in the cube
  • Measures (many)
    • Structure: Values in the centre table
    • OLAP: Numbers to display in cell cubes

Defining dimensions

Simple groupable values

Example:

Related table one step away

Example:


Related table TWO steps away

Example:


Enumerations / groups

Defining measures

Retrieved from "https://wiki.tempusserva.dk/index.php?title=Tutorial/Schema_cheatsheet&oldid=4687"