DisplayKey Element (CSDLBI)
APPLIES TO:SQL Server Analysis ServicesAzure Analysis Services
The DisplayKey element contains a list of the following elements that together constitute a strong identifier. The DisplayKey is found only as a child of the EntityType element. It can reference either columns or role ends.
Elements and Attributes
The following table lists the attributes of the DisplayKey element.
|IsDisplayKey||No||True or false.|
This element is for reports. The element to which you apply this attribute need not be the actual table key, only an element that you will present as the key. However, the column that you use for the DisplayKey must contain unique values.
The following sample, in CSDLBI version 1.1, shows a column in the AdventureWorks sample data model that has been designated as the DisplayKey for the table.
<sample in progress>
The following sample, in CSDLBI version 1.1, shows an excerpt from the representation of the Contoso Operations cube. In this model, the Color column has been marked as the display key for the Bikes table.
<EntityType Name="Bike"> .. .. .. <Property Name="Color" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Property ContextualNameRule="Context" Alignment="Left" Units="counts" SortDirection="Descending" IsRightToLeft="true" DefaultAggregateFunction="Max" /> </Property> .. .. .. <bi:EntityType> <bi:DisplayKey> <bi:MemberRef Name="Color" /> </bi:DisplayKey>> .. .. .. </bi:EntityType> </EntityType>