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]