Difference between revisions of "Tutorial/Schema cheatsheet"
Jump to navigation
Jump to search
<Level name="Category" column="Value" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
...
<Level name="Parent" column="PARENTNAME" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
...
</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 93: | Line 93: | ||
=== Related solution TWO steps away === | === Related solution TWO steps away === | ||
'''Structure''' | |||
{| | {| | ||
|Solutions as displayed | |Solutions as displayed | ||
| Line 106: | Line 106: | ||
|} | |} | ||
'''Data model''' | |||
* data_child | * data_child | ||
| Line 118: | Line 118: | ||
** GRANDPARENTNAME: Descriptive field | ** GRANDPARENTNAME: Descriptive field | ||
'''Cube schema''' | |||
... | ... | ||
<Table name="data_child"/> | <Table name="data_child"/> | ||
Revision as of 02:05, 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
Simple text/number values
Date/period values
Enumeration values
Standard lookup value
Structure
| Solution as displayed | "Sample solution" |
| Solution system names | sample |
| Database table names | data_sample |
Data model
- data_sample
- CATEGORY: Field containing the lookup value
Cube schema
...... <Dimension name="Example" foreignKey="CATEGORY"> <Hierarchy hasAll="true" primaryKey="LookupID">
Related solution ONE step away
Structure
| Solutions as displayed | "Some child" -> "Father or mother" |
| Solution system names | child -> parent |
| Database table names | data_child -> data_parent |
Data model
- data_child
- PARENT: Key to the "parent" solution
- data_parent
- GRANDPARENT: Key to the "grandparent" solution
- PARENTNAME: Descriptive field
Cube schema
...... <Dimension name="Example" foreignKey="PARENT"> <Hierarchy hasAll="true" primaryKey="DataID" primaryKeyTable="data_parent">
Related solution TWO steps away
Structure
| Solutions as displayed | "Some child" -> "Father or mother" |
| Solution system names | child -> parent |
| Database table names | data_child -> data_parent |
Data model
- data_child
- PARENT: Key to the "parent" solution
- data_parent
- GRANDPARENT: Key to the "grandparent" solution
- PARENTNAME: Descriptive field
- data_grandparent
- GRANDPARENTNAME: Descriptive field
Cube schema
...... <Dimension name="Example" foreignKey="PARENT"> <Hierarchy hasAll="true" primaryKey="DataID" primaryKeyTable="data_parent"> <Join leftKey="GRANDPARENT" rightKey="DataID">