Export (0) Print
Expand All
Expand Minimize

Define Relationship Dialog Box (Analysis Services)

Use the Define Relationship dialog box to define a relationship between a cube dimension and a measure group in Cube Designer. You can display the Define Relationship dialog box by clicking ... on a cell in the Grid pane on the Dimension Usage tab in Cube Designer.

Select relationship type

Select the type of dimension relationship to create between the cube dimension and the measure group. Selecting a dimension relationship type changes the contents of the Detail pane.

If No Relationship is chosen, a dimension relationship is not created.

Detail

Displays the options available for the dimension relationship type selected in Select relationship type.

The following options are displayed in the Detail pane, depending on the relationship type selected in Select relationship type:

Relationship type Description

No Relationship

No relationship is defined, and no options are displayed in the Detail pane.

Regular

Specifies a regular dimension relationship. The following options are displayed in the Detail pane:

Granularity attribute Select the attribute that defines the granularity of the measure group with respect to the dimension. This attribute is usually the key attribute of the dimension.
Dimension table Displays the main table for the dimension.
Measure group table Displays the fact table for the measure group.
Relationship
Displays a grid of dimension columns and measure group columns on which the relationship is based. The grid contains the following columns:

Option Description
Dimension Columns
Displays the columns associated with the selected granularity attribute.
Column Description
If the dimension has not yet been generated, this option is set to Generate.
ms178448.note(en-US,SQL.90).gifNote:

Measure Group Columns Select the columns in the measure group that are related to the dimension columns.
Advanced Click to display the Measure Group Bindings dialog box and edit advanced properties, such as null processing, on relationships between attributes and measure groups columns. For more information about the Measure Group Bindings dialog box, see Measure Group Bindings Dialog Box (SSAS).

Fact

Specifies a fact dimension relationship. The following options are displayed in the Detail pane:

Granularity attribute Select the attribute that defines the granularity of the measure group with respect to the dimension. This attribute is usually the key attribute of the dimension.
Dimension table Displays the primary dimension table.
Measure group table Displays the table on which the measure group is based.
Option Description

Referenced

Specifies a referenced dimension relationship. The following options are displayed in the Detail pane:

Reference dimension Displays the selected dimension.
Intermediate dimension Select the intermediate dimension
Reference dimension attribute Select the attribute in the reference dimension that is related to the intermediate dimension attribute specified in Intermediate dimension attribute.
Intermediate dimension attribute Select the attribute in the intermediate dimension that is related to the attribute in the reference dimension specified in Reference dimension.
Materialize Select to store the attribute member in the intermediate dimension that links the attribute in the reference dimension to the fact table in the MOLAP structure. Materializing the relationship is the default behavior to maximize query performance, but at the expense of an increase in processing time and storage space.
Option Description

Many-to-Many

Specifies a many-to-many dimension relationship. The following options are displayed in the Detail pane:

Dimension Displays the selected dimension.
Intermediate measure group
Select the associated intermediate measure group.
Option Description
The intermediate measure group must have at least one dimension in common with the selected measure group. Additionally, the granularity of the relationship between the intermediate measure group and the common dimension must be greater than or equal to the granularity between the common dimension and the selected measure group.
ms178448.note(en-US,SQL.90).gifNote:

Data Mining

Specifies a data mining dimension relationship. The following options are displayed in the Detail pane:

Target dimension
Displays the selected data mining dimension.
Option Description
You must select a data mining dimension to create a data mining dimension relationship.
ms178448.note(en-US,SQL.90).gifNote:

Source dimension Select the dimension on which the data mining dimension provides predictive analysis.

See Also

Reference

Dimension Usage (Cube Designer) (SSAS)
Analysis Services Designers and Dialog Boxes (SSAS)

Other Resources

Dimension Relationships
Lesson 5: Defining Relationships Between Dimensions and Measure Groups

Help and Information

Getting SQL Server 2005 Assistance
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft