Working with Associations in the CDS Data Preview

In CDS, an association represents the relationship between two CDS views.

Context

You use associations to:

Identify related CDS views. An association lists the hierarchy of related CDS views.
Navigate backwards and view the result sets of the previous CDS view in a hierarchy. Any filters applied to the result sets are retained.

Procedure

In the Project Explorer view, open the context menu of a DDL source and choose Open Data Preview.

Note
In addition, you can also open the Data Preview view from the source code editor of a DDL source. Then choose Open With Data Preview from the context menu.

Note If the selected CDS view requires parameters, a wizard for providing parameter values appears.

The Data Preview tool appears and displays the top 100 records by default.
In the table context menu, choose Follow Association.

Note
You can also choose > in the breadcrumb bar to follow an association.

Associations defined for the CDS view are listed.
Choose an association.

Results

The Data Preview tool displays the result set for the selected association. You can apply filters to the current result set or use the breadcrumb to navigate to the previous result set.

You can use the SQL Console option on the Data Preview menu to view the generated Open SQL query for an association. The generated query uses the SQL view to display records.