Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Define 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft