Defining Logical Relationships in a Data Source View (Analysis Services)
The Data Source View Wizard and Data Source View Designer automatically define relationships between tables added to a data source view, based on underlying database relationships, or based on the name matching criteria you specify, unless you disable. However, you may need to manually define logical relationships in the data source view to supplement those relationships that are defined automatically. Relationships are required in Microsoft SQL Server 2005 Analysis Services (SSAS) to identify fact and dimension tables, to construct queries for retrieving data and metadata from underlying data sources, and to take advantage of advanced business intelligence features.
You can define the following types of relationships in Data Source View Designer:
- A relationship from one table to another table in the same data source.
- A relationship from one table to itself, as in a parent-child relationship.
- A relationship from one table in a data source to another table in a different data source.
Note
The relationships defined in a data source view are logical and may not reflect the actual relationships defined in the underlying data source. You can create relationships in Data Source View Designer that do not exist in the underlying data source, and remove relationships created by Data Source View Designer from existing foreign key relationships in the underlying data source.
Relationships are directed. For every value in the source column, there is a corresponding value in the destination column. In a data source view diagram, such as the diagrams displayed in the Diagram pane, an arrow on the line between two tables indicates the direction of the relationship.
How To Add, Modify, View, or Delete Relationships
To view instructions about how to add, modify, view or delete relationships, see How to: Add, Delete, View, or Modify a Logical Relationship Using Data Source View Designer.
See Also
Tasks
How to: View Objects in a Data Source View Using Data Source View Designer
Concepts
Working with Data Source Views (Analysis Services)
Other Resources
Working with Data Source Views How-to Topics (SSAS)
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
14 April 2006 |
|