Hierarchy tab

For queries, it is easy to define a hierarchical depth to be taken into account for analyzing database content. Using the Hierarchy tab, you can define query items to be analyzed recursively. In order speed up the runtime of a query, you can define the hierarchical level of the elements to be analyzed. If you reduce the hierarchy level, fewer database elements are processed. Thus, it takes less time for the query result to be displayed.

Minimum

Values for minimum depth of hierarchy.

The minimum depth of hierarchy defines the hierarchy level the query should start analyzing.

The value depends on the value set for Maximum. The Minimum value must be less than or equal to the Maximum value. Settings will be corrected automatically.

You can use any value from 0 to n. If you select a lower value for Maximum the Minimum value is set automatically. If you select 0:0, the query is executed as a query without defined hierarchy depth. Analyzing a deep hierarchy may cause low performance.

Maximum

Values for maximum depth of hierarchy.

The maximum depth of hierarchy defines the deepest level in the structure to be analyzed.

The value depends on the value set for Minimum. The Maximum value must be greater than or equal to the Minimum value. Settings will be corrected automatically.

You can use any value from 0 to infinity (*). To see the very last item in the hierarchy you can enter *. Analyzing a deep hierarchy may cause low performance.

Connections

All relevant connections important for the hierarchical processing for the selected item are displayed.

You can Right arrow expand and Down arrow collapse the bullets.