Measure Group Bindings Dialog Box (Analysis Services - Multidimensional Data)

 

Applies To: SQL Server 2016

Use the Measure Group Bindings dialog box to create and modify direct relationships between non-granularity attributes in a cube dimension and columns in a measure group for a regular dimension relationship, as well as to specify null processing options for any attribute in a cube dimension, from the Define Relationship dialog box.

Measure group table
Displays the name of the fact table for the selected measure group.

Attributes
Displays a grid of attributes and dimension tables. Select an attribute to create or modify properties in Relationship for the selected attribute. The grid contains the following columns:

OptionDefinition
Attribute NameDisplays the name of the attribute.
Dimension TableDisplays the name of the dimension table on which the attribute is based.

Relationship
Displays a grid of relationships between dimension table columns for the selected attribute and fact table columns for the selected measure group as well as the null processing option for the relationship. The grid contains the following columns:

OptionDefinition
Dimension ColumnsDisplays the columns from the dimension table on which the attribute selected in Attributes is based.
Measure Group ColumnsSelect either Inherited from dimension to use the measure group relationship inherited from the dimension, or select a column from the fact table on which the measure group is based to explicitly define a relationship.
Null ProcessingSelect a null processing option for the attribute. For more information about null processing options, see NullProcessing Element (ASSL).

Define Relationship Dialog Box (Analysis Services - Multidimensional Data)
Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Community Additions

ADD
Show: