Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

NavigationProperty Element (CSDLBI)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

The NavigationProperty element is a complex type that extends the CSDL Member type, to support navigation in business intelligence data models.

Caution note Caution

This element is for reporting and cannot be modified or manipulated.

The following table lists the elements and attributes that define the NavigationProperty element.

Name

Is Required

Description

CollectionCaption

No

Plural name for referring to a set of instances of the navigation property.

If this attribute is omitted, the Caption attribute of the base Member is used.

Tabular

The following example shows a navigation property in CSDLBI version 1.1 that describes the link between the Product SubCategory table and the Product table in a tabular model.

<NavigationProperty 
    Name="Product_Sub_Category_ProductSubcategoryKey"    
    Relationship="Sandbox.Product_Product_Sub_Category_Product_Sub_Category_ProductSubcategoryKey"
     FromRole="Product_ProductSubcategoryKey" 
    ToRole="Product_Sub_Category_ProductSubcategoryKey">
<bi:NavigationProperty 
     ReferenceName="Product Sub-Category_ProductSubcategoryKey" />
</NavigationProperty>

Multidimensional

The following example shows a navigation property in CSDLBI version 1.1 that describes the relationship between two tables in the Contoso Operations cube. The relationship connects the Bike Category table and the Product Subcategory table.

<NavigationProperty 
     Name="BikeSubcategory_ProductSubcategoryKey" 
     Relationship="Sandbox.Bike_BikeSubcategory_BikeSubcategory_ProductSubcategoryKey" 
     FromRole="Bike_ProductSubcategoryKey" 
     ToRole="BikeSubcategory_ProductSubcategoryKey">
   <bi:NavigationProperty />
</NavigationProperty>

Community Additions

ADD
Show:
© 2015 Microsoft