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 33: | Line 33: | ||
* data_parent | * data_parent | ||
** GRANDPARENT: Key to the "grandparent" solution | ** GRANDPARENT: Key to the "grandparent" solution | ||
** PARENTNAME | ** PARENTNAME: Descriptive field | ||
* data_grandparent | * data_grandparent | ||
** GRANDPARENTNAME | ** GRANDPARENTNAME: Descriptive field | ||
The cube schema looks like this: | The cube schema looks like this: | ||
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: Descriptive field
- data_grandparent
- GRANDPARENTNAME: Descriptive field
The cube schema looks like this:
...... <Dimension name="Example" foreignKey="PARENT"> <Hierarchy hasAll="true" primaryKey="DataID" primaryKeyTable="data_parent"> <Join leftKey="GRANDPARENT" rightKey="DataID">