AssociationSet Element (CSDLBI)
Important: This document is archived. For the latest information, refer to Open Specification [MS-CSDLBI]: Conceptual Schema Definition File Format with Business Intelligence Annotations.
The AssociationSet element is a complex type that defines an association. In a CSDLBI data model, an association is a relationship between two tables.
An AssociationSet must be specified for each unique relationship in a model. The AssociationSet defines the endpoints by using the Association element. The AssociationSet element also defines metadata about the relationship and its usage in the data model.
Applicable Attributes
The following table lists the elements and attributes that define the AssociationSet element.
| Name | Is Required | Description |
|---|---|---|
| State | Yes | A string that indicates whether the association is active or not. The value is defined by the State element. |
| Hidden | No | A Boolean value that indicates whether the relationship is visible. By default, the value of Hidden is false, meaning all relationships are visible in the model. |
State Element
The State element is a simple type that describes whether an association is active, and should be used in calculations, or is inactive, and must be explicitly referenced in calculations.
If there are multiple association sets connecting two entities, no more than one association set can be marked Active. In other words, if there are two relationships between the same two tables, only one relationship can be active.
The following table lists the values of the State element.
| Value | Description |
|---|---|
| Active | The association is active. |
| Inactive | The association is active. |
Example Tabular
The following sample shows a relationship in the AdventureWorks tabular model) (in CSDLBI version 1.1). The association is marked as Inactive, because there is an existing relationship (between OrderKey and Date).
<AssociationSet
Name="InternetSales_Date_Date_Date"
Association="Sandbox.InternetSales_Date_Date_Date">
<End EntitySet="InternetSales" />
<End EntitySet="DimDate" />
<bi:AssociationSet State="Inactive" />
</AssociationSet>
Example Multidimensional
The following sample shows the relationship that is defined between the Sales and Currency tables, in the Contoso Operations cube.
<AssociationSet
Name ="Sales_Currency_Currency_Currency_Name2"
Association ="Sandbox.Sales_Currency_Currency_Currency_Name2">
<End EntitySet ="Sales" />
<End EntitySet ="Currency" />
<bi:AssociationSet />
</AssociationSet>