Skip to content

Edit Tree

Edits a tree.

Permissions

Command KindNeeded User Kind
WriteAll

Parameters

NameTypeDescriptionRequiredDefaultValues
DimensionstringName of the dimension ([Dimension]).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
AddNewItemsbooleanIf 'True' a new dimension item is added to the top level of the tree. The default value is 'False'.nofalse
BuilderstringFunction to build tree sums automatically. Dimension items are assigned to sums via functions, e.g. StrStarts("Cost_",Name())no
BuilderSortstringSort order of the builder function: [Name], [Caption1], [Caption2], [Caption3], [Caption4], [Caption5], [Caption6], [Caption7], [Caption8], [Caption9] or [Caption10].no
Caption1stringCaption 1no
Caption2stringCaption 2no
Caption3stringCaption 3no
Caption4stringCaption 4no
Caption5stringCaption 5no
Caption6stringCaption 6no
Caption7stringCaption 7no
Caption8stringCaption 8no
Caption9stringCaption 9no
Caption10stringCaption 10no
DefaultbooleanIf 'True' the tree becomes the default tree. The tree name '<Default>' is a reference to the default tree. The default value is 'False'.nofalse
NamestringNew name of the tree ([Name]).no

Result

NameTypeDescription
TreestringName of the tree.
Caption1stringCaption 1
Caption2stringCaption 2
Caption3stringCaption 3
Caption4stringCaption 4
Caption5stringCaption 5
Caption6stringCaption 6
Caption7stringCaption 7
Caption8stringCaption 8
Caption9stringCaption 9
Caption10stringCaption 10
AddNewItemsbooleanIf 'True' and a new dimension item is created, it is added to the top level of the tree.
DefaultbooleanIf 'True' the tree name '<Default>' is a reference to this tree.
BuilderstringFunction to build automatically tree sums.
BuilderSortstringSort order of the builder function: Name, Caption1, Caption2, Caption3, Caption4, Caption5, Caption6, Caption7, Caption8, Caption9 or Caption10.
SumsintegerNumber of sums of the tree.
ItemsintegerNumber of dimension items of the tree.
MaxLevelintegerMax level of the tree.
SubtreesintegerNumber of subtrees of the tree.

Code

text
EDIT TREE
DIMENSION=[string, Needed]
TREE=[string, Needed]
ADDNEWITEMS=[boolean, default=false]
BUILDER=[string]
BUILDERSORT=[string]
CAPTION1=[string]
CAPTION2=[string]
CAPTION3=[string]
CAPTION4=[string]
CAPTION5=[string]
CAPTION6=[string]
CAPTION7=[string]
CAPTION8=[string]
CAPTION9=[string]
CAPTION10=[string]
DEFAULT=[boolean, default=false]
NAME=[string]