Set Tree Items

Sets the items of a tree.

Permissions

Command Kind	Needed User Kind
Write	All

Parameters

Name	Type	Description	Required	Default	Values
Dimension	string	Name of the dimension ([Dimension]).	yes
Tree	string	Name 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 dimension	yes
Adjust	boolean	If 'True' protected command chars are replaced: '[' becomes '(', ']' becomes ')' and '=' becomes empty. The default value is 'True'.	no	true
Create	boolean	If 'True' a non existing tree will be created. The default value is 'False'.	no	false
CreateItems	boolean	If 'True' a non existing item will be created. The default value is 'False'.	no	false
EditItems	boolean	The item can include captions and attributes. If 'True', the captions and attributes are used to update captions and attributes of the corresponding dimension items. The default value is 'False'.	no	false
FieldSeparator	string	Field separator (long and short): Circumflex (^), Comma (,), Semicolon (😉, Tabulator (Tab) or Pipe (|). The default separator is Tab.	no
IgnoreErrors	boolean	If 'True' errors are ignored. If 'False' the command is stopped and an error message is displayed. The default value is 'False'.	no	false
Item	array of string	Item with parent, name, captions, attribute, factor, invisible, KPI, builder function and builder sort. The fields are separated by the 'FieldSeparator' char. A semicolon can be used ([Parent];[Item];[Caption1];[Caption2];[Caption3];[Caption4];[Caption5];[Caption6];[Caption7];[Caption8];[Caption9];[Caption10];[Attribute]), e.g. [Profit];[1234];[Product 1234];[];[];[];[];[];[];[];[];[];[Size].[L],[Color].[Blue];[1];[False];;;	no
Sum	array of string	Sum with parent, name, factor, captions, attribute, factor, invisible, KPI, builder function and builder sort. The fields are separated by the 'FieldSeparator' char. A semicolon can be used ([Parent];[Item];[Caption1];[Caption2];[Caption3];[Caption4];[Caption5];[Caption6];[Caption7];[Caption8];[Caption9];[Caption10];[Attribute]),e.g. [<Top>];[Profit];[Profit Total];[];[];[];[];[];[];[];[];[];;;[1];[False];[Personnel Costs],[Material Costs],[Marketing costs].[%].[Turnover];StrStarts("Cost_",Name());[Caption1]	no
Top	string	Parent text for the top level items and sums. The default value is '<Top>'.	no	<Top>

Result

No fields

Code

SET TREE ITEMS
DIMENSION=[string, Needed]
TREE=[string, Needed]
ADJUST=[boolean, default=true]
CREATE=[boolean, default=false]
CREATEITEMS=[boolean, default=false]
EDITITEMS=[boolean, default=false]
FIELDSEPARATOR=[string]
IGNOREERRORS=[boolean, default=false]
ITEM=[string, Multiple]
SUM=[string, Multiple]
TOP=[string, default=<Top>]