Difference between revisions of "Tutorial/Schema cheatsheet"
Jump to navigation
Jump to search
</Join>
<Level name="Grandparent" table="data_grandparent" column="GRANDPARENTNAME" uniqueMembers="true"/>
<Level name="Parent" table="data_parent" column="PARENTNAME" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
...
old>Admin |
old>Admin |
||
| Line 28: | Line 28: | ||
=== Related table TWO steps away === | === Related table TWO steps away === | ||
Table structure | |||
* | * data_child | ||
* | ** PARENT: Key to the "parent" solution | ||
* PARENT | |||
* data_parent | * data_parent | ||
** GRANDPARENT: Key to the "grandparent" solution | |||
** PARENTNAME | |||
* data_grandparent | * data_grandparent | ||
** GRANDPARENTNAME | |||
The cube schema looks like this: | The cube schema looks like this: | ||
... | |||
<Table name="data_child"/> | |||
... | |||
<Dimension name="Example" foreignKey="PARENT"> | <Dimension name="Example" foreignKey="PARENT"> | ||
<Hierarchy hasAll="true" primaryKey="DataID" primaryKeyTable="data_parent"> | <Hierarchy hasAll="true" primaryKey="DataID" primaryKeyTable="data_parent"> | ||
| Line 52: | Line 52: | ||
</Hierarchy> | </Hierarchy> | ||
</Dimension> | </Dimension> | ||
... | |||
=== Enumerations / groups === | === Enumerations / groups === | ||
Revision as of 01:19, 28 February 2014
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
Table structure
- data_child
- PARENT: Key to the "parent" solution
- data_parent
- GRANDPARENT: Key to the "grandparent" solution
- PARENTNAME
- data_grandparent
- GRANDPARENTNAME
The cube schema looks like this:
...... <Dimension name="Example" foreignKey="PARENT"> <Hierarchy hasAll="true" primaryKey="DataID" primaryKeyTable="data_parent"> <Join leftKey="GRANDPARENT" rightKey="DataID">