Skip to content

Show Subtree Items ​

Shows the subtree items.

Permissions ​

Command KindNeeded User Kind
ReadAll

Parameters ​

NameTypeDescriptionRequiredDefaultValues
DimensionstringName of the dimension ([Dimension]).yes
SubtreestringName of the subtree ([Subtree]). A subtree is a flat extract of items and sums of the tree.yes
TreestringName of the tree ([Tree]). A tree is a hierarchical structure of a dimension. A tree is build of sums. These sums can contain other sums or elements of the dimensionyes
SumsOnlybooleanIf 'True' only sums are shown. The default value is 'False'.nofalse

Result ​

NameTypeDescription
TypestringType of the subtree item: Item or Sum.
NamestringName of the subtree item.
Caption1stringCaption 1
Caption2stringCaption 2
Caption3stringCaption 3
Caption4stringCaption 4
Caption5stringCaption 5
Caption6stringCaption 6
Caption7stringCaption 7
Caption8stringCaption 8
Caption9stringCaption 9
Caption10stringCaption 10
AttributesstringIf 'Type' is 'Item', it contains a list of the attributes of the dimension item.

Code ​

text
SHOW SUBTREE ITEMS
DIMENSION=[string, Needed]
SUBTREE=[string, Needed]
TREE=[string, Needed]
SUMSONLY=[boolean, default=false]