TreeView Transform

image_pdfimage_print

This transform can filter and the 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 choose “element”. To define a filter on an attribute value of the source, choose 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

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.

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.

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 source can be sorted on the element name or an any of the tree attributes in ascending or descending order. Multiple sort criteria can be defined. 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 are ordered. Note: this can best be seen when displaying the tree with format “EA”.

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...