Analyzing Dependencies in Complex CDS Entities

You use the Dependency Analyzer to view and analyze SQL dependency tree of views when implementing more complex CDS views (based on view on view pattern).

Prerequisites

The SQL dependency of data sources can only be calculated for active version of the DDL source.

Context

To open the Dependency Analyzer, proceed as follows:

Procedure

In the Project Explorer, select the DDL source that includes the CDS view to be analyzed.
Open the context menu and choose Open with Dependency Analyzer .

Tip
Alternatively, you can open the same context menu from the DDL editor of the relevant CDS entity.

Results

The dependency of data sources involved in the CDS view definition is calculated and displayed in a tree structure (SQL Dependency Tree tab).