Tutorial/Schema cheatsheet

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

Descriptive fields

• PARENTNAME
• GRANDPARENTNAME

Keys between tables

• PARENT
• GRANDPARENT

Tables

• data_parent
• data_grandparent

The cube schema looks like this:

   <Dimension name="Example" foreignKey="PARENT">
       <Hierarchy hasAll="true" primaryKey="DataID" primaryKeyTable="data_parent">
           <Join leftKey="GRANDPARENT" rightKey="DataID">

</Join> <Level name="Grandparent" table="data_grandparent" column="GRANDPARENTNAME" uniqueMembers="true"/> <Level name="Parent" table="data_parent" column="PARENTNAME" uniqueMembers="true"/> </Hierarchy> </Dimension>