Additional relationships depend on the number of level entities that exist. These additional relationships include the relationships between level and dimensions entities and property entities, levels and dimensions and the cube fact entity, and between measures and the cube fact entity.
Level and Dimensions Entities and Property Entities
If the property entity is located at the bottom level of a dimension entity, create a relationship between the dimension entity and the property. If the property entity is not located at the bottom level of the dimension entity, create a relationship between the entity for the level containing the property and the property entity itself.
Levels and Dimensions and the Cube Fact Entity
Relationships are created between level and dimension entities and the entity associated with the cube's fact table. Although the fact table entity has relationships to each level entity of each dimension and each dimension entity, relationships are not created between the fact entity and the bottom-most level of a multilevel dimension, the name/ID level. For example, the following relationships and phrasings can occur between level (cities, states, and countries) and dimension entities (customer) and the cube fact entity (sales):
- customers have sales
- cities have sales
- states have sales
- countries have sales
Relationships Between Measures and the Cube Fact Entity
The OLAP Project Wizard also creates relationships between the OLAP cube fact entity and the entities of all of the cube's measures. Using the previous example, the following relationships would be created between the cube fact entity (sales) and the measures (unit sales, store cost, store sales, sales count, and store sales net):
- sales have unit sales
- sales have store cost
- sales have store sales
- sales have sales count
- sales have store sales net