Defining a Fact Relationship and Fact Relationship Properties
When you define a new cube dimension or a new measure group, Analysis Services will try to detect if a fact dimension relationship exists and then set the dimension usage setting to Fact. You can view or edit a fact dimension relationship on the Dimension Usage tab of Cube Designer. The fact relationship between a dimension and a measure group has the following constraints:
- A cube dimension can have only one fact relationship to a particular measure group.
- A cube dimension can have separate fact relationships to multiple measure groups.
- The granularity attribute for the relationship must be the key attribute (such as Transaction Number) for the dimension. This creates a one-to-one relationship between the dimension and facts in the fact table.