| title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
|---|---|---|---|---|---|---|---|---|
Configure Attribute Relationship Properties | Microsoft Docs |
See a table that lists and describes the properties of an attribute relationship, like Name, Visibility, and RelationshipType. |
05/02/2018 |
analysis-services |
multidimensional-models |
conceptual |
kfollis |
kfollis |
kfollis |
[!INCLUDEappliesto-sqlas] The following table lists and describes the properties of an attribute relationship.
| Property | Description |
|---|---|
| Attribute | Contains the name of the attribute. |
| Cardinality | Indicates the cardinality of the relationship. Values are Many, for a many to one relationship, or One, for a one to one relationship. Default value is Many. In [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion], the cardinality property has no effect - its use is reserved for a future implementation. |
| Name | Contains the friendly name of the attribute. |
| RelationshipType | Indicates whether member relationships change over time. Values are Rigid, which means that relationships between members do not change over time, or Flexible, which means that relationships between members change over time. Default is Flexible. If you define a relationship as flexible, aggregations are dropped and recomputed as part of an incremental update (they will not be dropped if only new members are added). If you define a relationship as rigid, [!INCLUDEssASnoversion] retains aggregations when the dimension is incrementally updated. If a relationship that is defined as rigid actually changes, [!INCLUDEssASnoversion] generates an error during incremental processing. Specifying the appropriate relationships and relationship properties increases query and processing performance. |
| Visible | Determines the visibility of the attribute relationship. Values are True or False. Default is True. |