SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Analysis Services - Multidimensional Data
Technical Reference
Feature Reference
Analysis Services F1 Help (Analysis Services - Multidimensional Data)
Analysis Services Designers and Dialog Boxes (Analysis Services - Multidimensional Data)
Add Cube Dimension Dialog Box (Analysis Services - Multidimensional Data)
Add Reference Dialog Box (Analysis Services - Multidimensional Data)
Add Table Dialog Box (Analysis Services - Multidimensional Data)
Add/Remove Tables Dialog Box (Analysis Services - Multidimensional Data)
Analysis Server Properties Dialog Box (Analysis Services - Multidimensional Data)
Assembly Properties Dialog Box (Analysis Services - Multidimensional Data)
Assign Aggregation Design Dialog Box (Analysis Services - Multidimensional Data)
Attribute Data Translation Dialog Box (Analysis Services - Multidimensional Data)
Backup Database Dialog Box (Analysis Services - Multidimensional Data)
Browse Data Source Dialog Box (Analysis Services - Multidimensional Data)
Browse Data Source View Dialog Box (Analysis Services - Multidimensional Data)
Browse for Remote Folder Dialog Box (Analysis Services - Multidimensional Data)
Calculated Member Builder Dialog Box (Analysis Services - Multidimensional Data)
Calculation Properties Dialog Box (Analysis Services - Multidimensional Data)
Change Settings Dialog Box (Analysis Services - Multidimensional Data)
Connection Manager Dialog Box (Analysis Services - Multidimensional Data)
Create Attribute Relationship and Edit Attribute Relationship Dialog Boxes (Attribute Relationship Designer Tab, Dimension Designer) (Analysis Services - Multidimensional Data)
Create/Edit Named Calculation Dialog Box (Analysis Services)
Create/Edit Named Query Dialog Box (Analysis Services - Multidimensional Data)
Create/Edit Relationship Dialog Box (Analysis Services - Multidimensional Data)
Create Polling Query Dialog Box (Analysis Services - Multidimensional Data)
Create Processing Query Dialog Box (Analysis Services - Multidimensional Data)
Cube Designer (Analysis Services - Multidimensional Data)
Cube Properties Dialog Box (Analysis Services - Multidimensional Data)
Data Exploration Options Dialog Box (Analysis Services - Data Mining)
Data Sample Viewer Dialog Box (Analysis Services - Multidimensional Data)
Data Source Designer Dialog Box (Analysis Services)
Data Source Properties Dialog Box (Analysis Services - Multidimensional Data)
Data Source View Designer (Analysis Services - Multidimensional Data)
Data Source View Properties Dialog Box (Analysis Services - Multidimensional Data)
Database Designer (Analysis Services - Multidimensional Data)
Database Properties Dialog Box (Analysis Services - Multidimensional Data)
Define Relationship Dialog Box (Analysis Services - Multidimensional Data)
Delete objects and files Dialog Box (Analysis Services)
Dimension Designer (Analysis Services - Multidimensional Data)
Dimension Properties Dialog Box (Analysis Services - Multidimensional Data)
Dismiss Warning Dialog Box (Analysis Services - Multidimensional Data)
Analysis Services Duplicate Security Role Dialog Box (Analysis Services - Multidimensional Data)
Enable/Disable Writeback Dialog Box (Analysis Services - Multidimensional Data)
Explore Data Dialog Box (Analysis Services - Multidimensional Data)
Filter Members Dialog Box (Analysis Services - Multidimensional Data)
Find Table Dialog Box (Analysis Services - Multidimensional Data)
Generate Named Query Dialog Box (Analysis Services - Multidimensional Data)
Impact Analysis Dialog Box (Analysis Services - Multidimensional Data)
Impersonation Information Dialog Box (Analysis Services - Multidimensional Data)
Incremental Update Dialog Box (Analysis Services - Multidimensional Data)
Key Columns Dialog Box (Analysis Services - Multidimensional Data)
Level Naming Template Dialog Box (Analysis Services - Multidimensional Data)
Locate Database Files Dialog Box (Analysis Services - Multidimensional Data)
MDX Builder Dialog Box (Analysis Services - Multidimensional Data)
MDX Query Editor (Analysis Services - Multidimensional Data)
Measure Group Bindings Dialog Box (Analysis Services - Multidimensional Data)
Merge Partition Dialog Box (Analysis Services - Multidimensional Data)
New Database Dialog Box (Analysis Services)
New Measure Dialog Box (Analysis Services - Multidimensional Data)
New Measure Group Dialog Box (Cube Designer)
Object Binding Dialog Box
Partition Properties Dialog Box (SSMS)
Partition Source Dialog Box (Analysis Services - Multidimensional Data)
Process Dialog Box (Analysis Services - Multidimensional Data)
Process Progress Dialog Box (Analysis Services - Multidimensional Data)
Refresh Data Source View Dialog Box
Register Server Assembly Dialog Box (Analysis Services - Multidimensional Data)
Relational Objects Dialog Box (Analysis Services - Multidimensional Data)
Remote Partitions - Advanced Settings Dialog Box (Analysis Services - Multidimensional Data)
Rename Instance Dialog Box (Analysis Services)
Replace Table with Other Table Dialog Box
Restore Database Dialog Box (Analysis Services - Multidimensional Data)
Role Designer (Analysis Services - Multidimensional Data)
Save File As Dialog Box (Analysis Services - Multidimensional Data)
Security Context Dialog Box (Analysis Services - Multidimensional Data)
Select Language Dialog Box (Analysis Services - Multidimensional Data)
Select Parent Member Dialog Box (Analysis Services - Multidimensional Data)
Show Table Dialog Box (Analysis Services - Multidimensional Data)
Storage Options Dialog Box (Analysis Services - Multidimensional Data)
Storage Settings Dialog Box (Analysis Services - Multidimensional Data)
User Selection Dialog Box (Analysis Services - Multidimensional Data)
View Details Dialog Box (Analysis Services - Multidimensional Data)
XMLA Query Editor (Analysis Services - Multidimensional Data)
Expand Minimize
This topic has not yet been rated - Rate this topic

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

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:

Option

Definition

Attribute Name

Displays the name of the attribute.

Dimension Table

Displays 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:

Option

Definition

Dimension Columns

Displays the columns from the dimension table on which the attribute selected in Attributes is based.

Measure Group Columns

Select 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 Processing

Select a null processing option for the attribute. For more information about null processing options, see NullProcessing Element (ASSL).

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.