Export Formula

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

Permissions

Command Kind	Needed User Kind
Read	Admin, Sys

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
Formula	string	Name of the formula ([Formula]). A formula is a flat structure of a dimension. A Formula is build of items and sums. Sums are calculated with functions.	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
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
Input	boolean	If 'True' the input function 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
Rubric	boolean	If 'True' the rubric is exported. The default value is 'True'.	no	true

Result

No fields

Code

EXPORT FORMULA
DIMENSION=[string, Needed]
FILE=[string, Needed]
FORMULA=[string, Needed]
ATTRIBUTE=[boolean, default=true]
BRACKETS=[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]
INPUT=[boolean, default=true]
MAXRECORDS=[integer, default=500000]
QUOTED=[boolean, default=false]
RUBRIC=[boolean, default=true]