Export Tree

Exports a tree to a text file. The text file is saved on the server.

Permissions

Command Kind	Needed User Kind
Read	All

Parameters

Name	Type	Description	Required	Default	Values
Dimension	string	Name of the dimension ([Dimension]).	yes
File	string	Name/path of the export file. The file is exported on the server.	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
Attribute	boolean	If 'True' attributes are exported. The default value is 'True'.	no	true
Brackets	boolean	If 'True' the dimension items are exported with brackets ([Item]). The default value is 'True'.	no	true
Builder	boolean	If 'True' the builder function for sums is exported. The default value is 'True'.	no	true
BuilderSort	boolean	If 'True' the builder sort order for sums is exported. The default value is 'True'.	no	true
Caption1	boolean	If 'True' caption 1 is exported. The default value is 'True'.	no	true
Caption2	boolean	If 'True' caption 2 is exported. The default value is 'True'.	no	true
Caption3	boolean	If 'True' caption 3 is exported. The default value is 'True'.	no	true
Caption4	boolean	If 'True' caption 4 is exported. The default value is 'True'.	no	true
Caption5	boolean	If 'True' caption 5 is exported. The default value is 'True'.	no	true
Caption6	boolean	If 'True' caption 6 is exported. The default value is 'True'.	no	true
Caption7	boolean	If 'True' caption 7 is exported. The default value is 'True'.	no	true
Caption8	boolean	If 'True' caption 8 is exported. The default value is 'True'.	no	true
Caption9	boolean	If 'True' caption 9 is exported. The default value is 'True'.	no	true
Caption10	boolean	If 'True' caption 10 is exported. The default value is 'True'.	no	true
Coding	string	Coding of the file: Ansi, Ascii, BigEndianUnicode, Unicode (Utf16/Utf-16), Utf7 (Utf-7) or Utf8 (Utf-8). The default value is Utf8.	no	Utf8	Ansi, Ascii, BigEndianUnicode, Unicode, Utf7, Utf8
DecimalSeparator	string	Decimal separator (long and short): Comma (,) or Point (.). The default value is Point (.)	no	Point	Comma, Point
Factor	boolean	If 'True' the factor is exported. The default value is 'True'.	no	true
FieldSeparator	string	Field separator (long and short): Circumflex (^), Comma (,), Semicolon (😉, Tabulator (Tab) or Pipe (|).	no	Tabulator	Circumflex, Comma, Semicolon, Tabulator, Pipe
Header	boolean	If 'True' the header is exported. The default value is 'True'.	no	true
Invisible	boolean	If 'True' invisible is exported. The default value is 'True'.	no	true
Kpi	boolean	If 'True' the KPI function for sums is exported. The default value is 'True'.	no	true
MaxRecords	integer	Maximum number of records to be exported. The default value is 500000.	no	500000
Quoted	boolean	If 'True' the text fields are quoted ("Text"). The default value is 'False'.	no	false
Top	string	Parent text for the top level items and sums. The default value is '<Top>'.	no	<Top>

Result

No fields

Code

EXPORT TREE
DIMENSION=[string, Needed]
FILE=[string, Needed]
TREE=[string, Needed]
ATTRIBUTE=[boolean, default=true]
BRACKETS=[boolean, default=true]
BUILDER=[boolean, default=true]
BUILDERSORT=[boolean, default=true]
CAPTION1=[boolean, default=true]
CAPTION2=[boolean, default=true]
CAPTION3=[boolean, default=true]
CAPTION4=[boolean, default=true]
CAPTION5=[boolean, default=true]
CAPTION6=[boolean, default=true]
CAPTION7=[boolean, default=true]
CAPTION8=[boolean, default=true]
CAPTION9=[boolean, default=true]
CAPTION10=[boolean, default=true]
CODING=[string, default=Utf8, values=[Ansi,Ascii,BigEndianUnicode,Unicode,Utf7,Utf8]]
DECIMALSEPARATOR=[string, default=Point, values=[Comma,Point]]
FACTOR=[boolean, default=true]
FIELDSEPARATOR=[string, default=Tabulator, values=[Circumflex,Comma,Semicolon,Tabulator,Pipe]]
HEADER=[boolean, default=true]
INVISIBLE=[boolean, default=true]
KPI=[boolean, default=true]
MAXRECORDS=[integer, default=500000]
QUOTED=[boolean, default=false]
TOP=[string, default=<Top>]