|Dependency Browser Dialog|
Shows computed column and validator dependencies in a tree view.
Browse computed column and validator dependencies.
"Function" node is a child node of a column node. Node text is the functions type name. Child nodes (function parameters) can be column nodes or constant parameters (direct dependencies).
"Triggers" node is a child node of a column node. Child nodes are all computed columns and validators with direct dependency to paraen column. ("Triggers" means: changing column value will trigger invalidation of direct dependent items.)
"Depends on" node is a child node of a column and validator node. Its child nodes are all (direct and indirect) dependencies (flatten hirarchy).
Parameter Column Association
Represents a parameter linked with a column via access path (see Access Path Browser Dialog).
Represents a parameter with constant value (see value in PARAMETER Properties).
Parameter Column with Self Reference
Parameter will contain the cells previous value.
Parameter Column Association with Runtime-Preventable Circular Reference
Possible circular reference at runtime.
When accessing parameters via self joins (relation where same table is at relations parent and child end) a circular reference may occur (e.g. A row is its own parent row and column "Height" is computed as sum of child rows "Height").
Parameter Column Association with NOT Preventable Circular Reference at Runtime
A circular reference in dependencies (e.g. Column "A" depends on column "B" of same row and column "B" depends on column "A" of same row).