TreeView Transform

This transform can filter and sort a tree-based source.

Filtering

Filtering is possible according to the name of elements, the hierarchy, and the attribute values of the elements. It is more flexible than the transform type TableView, and can also preserve the tree structure of the source.

Attribute

To define a filter on the element name (default), keep this entry empty or select “element”. To define a filter on an attribute value of the source, select one of the attributes.

Filter Type

accept All nodes that fulfill the filter criteria are included in the selection.
deny All nodes that fulfill the filter criteria are excluded from the selection.

Operators

The values for each expression depend on the operator used; specific values are noted when necessary in the descriptions below.

equal Filtering occurs according to the element specified.
inAlpharange Alphanumerical values in a particular range are filtered.

Examples:

inclusive range: “[A100,A200]”
exclusive range: “(A100,A200)”
half-open interval: “[A100,)”
half-open interval: “(,A100)”
inrange Numerical values in a particular range are filtered.

Examples:

inclusive range: “[100,200]”
exclusive range: “(100,200)”
half-open interval: “[100,)”
half-open interval: “(,100)”
isEmpty The element is empty or consists only of space values. For this operator, the Value field should be left blank.
like Filters the dimension elements according to regular expressions.

Modes

nodesToBases All bases under the selected value are filtered, including the selected element.
onlyBases All base elements under the selected value are filtered.
onlyChildren All children elements of the selected value are filtered.
onlyNodes Only the selected element is filtered out.
onlyRoot Only the element from the highest level of the hierarchy is filtered out, based on the selected element.
rootToBase Based on the selected element, this element and the elements above and below are filtered out.
rootToConsolidate Only consolidated elements above the selected element are filtered out.
rootToNode Only consolidated elements that are above the selected elements in the hierarchy are filtered out.

For examples, especially for the different modes, see Dimension Extract.

Sorting

The tree sources can be sorted based on different sorting Inputs:

  • :element : the name of the element

  • :level : the numerical level of the element in the hierarchy i.e., the depth in the tree

  • <attribute name> : a tree attribute value

Elements can be sorted in ascending or descending order, with or without case sensitivity. Multiple sort criteria can also be defined.

Sort Children

The TreeView transform sorts the child consolidations for each tree node in alphanumerical order.

Sort positions

If this option is set in addition to the child consolidations, the global position of the elements in the tree is ordered. The screenshot below shows the difference between the enabled and disabled “Sort positions” options.

Note: this can best be seen when displaying the tree with format "EA".

Updated November 5, 2024