Additional Relationships
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
- 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
- sales have unit sales
- sales have store cost
- sales have store sales
- sales have sales count
- sales have store sales net