Set Formula Items

Sets the items and sums of a formula.

Permissions

Command Kind	Needed User Kind
Write	All

Parameters

Name	Type	Description	Required	Default	Values
Dimension	string	Name of the dimension ([Dimension]).	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
Adjust	boolean	If 'True' protected command chars are replaced: '[' becomes '(', ']' becomes ')' and '=' becomes empty. The default value is 'True'.	no	true
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 change the dimension items. The default value is 'False'.	no	false
FieldSeparator	string	Field separator (long and short): Circumflex (^), Comma (,), Semicolon (😉, Tabulator (Tab) or Pipe (|).	no	Tabulator	Circumflex, Comma, Semicolon, Tabulator, Pipe
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 name, factor, captions, attribute, rubric, factor and invisible. The fields are separated by the 'FieldSeparator' char. A semicolon can be used ([Item];[Caption1];[Caption2];[Caption3];[Caption4];[Caption5];[Caption6];[Caption7];[Caption8];[Caption9];[Caption10];[Attribute];[Rubric];[Factor];[Invisible]), e.g. [1234];[Product 1234];[];[];[];[];[];[];[];[];[];[Size].[L],[Color].[Blue];[Product];[1];[False]	no
Sum	array of string	Sum with name, factor, captions, attribute, rubric, factor, invisible and input. The fields are separated by the 'FieldSeparator' char. A semicolon can be used ([Sum];[Caption1];[Caption2];[Caption3];[Caption4];[Caption5];[Caption6];[Caption7];[Caption8];[Caption9];[Caption10];[Attribute];[Rubric];[Factor];[Invisible];Input), e.g. [Costs];[Costs Total];[];[];[];[];[];[];[];[];[];[Size].[L],[Color].[Blue];[Product];[1];[False];SumRange("Cost 1","Cost 10")	no

Result

No fields

Code

SET FORMULA ITEMS
DIMENSION=[string, Needed]
FORMULA=[string, Needed]
ADJUST=[boolean, default=true]
CREATEITEMS=[boolean, default=false]
EDITITEMS=[boolean, default=false]
FIELDSEPARATOR=[string, default=Tabulator, values=[Circumflex,Comma,Semicolon,Tabulator,Pipe]]
IGNOREERRORS=[boolean, default=false]
ITEM=[string, Multiple]
SUM=[string, Multiple]