Set Distribution Items

Sets the items of a distribution.

Permissions

Command Kind	Needed User Kind
Write	All

Parameters

Name	Type	Description	Required	Default	Values
Dimension	string	Name of the dimension ([Dimension]).	yes
Distribution	string	Name of the distribution ([Distribution]). A distribution contains items of a dimension. Each item has a factor. The factor is used to distribute values over the items.	yes
Item	array of string	Item with name, factor, captions and attribute. Normally only name and factor is used. The captions and attribute can be used to edit the dimension item. The fields are separated by the 'FieldSeparator' char. A semicolon can be used ([Item];[Factor];[Caption1];[Caption2];[Caption3];[Caption4];[Caption5];[Caption6];[Caption7];[Caption8];[Caption9];[Caption10];[Attribute]), e.g. [1234];[2];[Product 1234];[];[];[];[];[];[];[];[];[];[Size].[L],[Color].[Blue]	yes
Create	boolean	If 'True' a non existing distribution will be created. The default value is 'False'.	no	false
DateOffset	integer	Moves the date dimension items by the offset. The default value is '0'. For example the month '2022-02' with an offset of 5 becomes '2022-07'.	no	0
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

Result

No fields

Code

SET DISTRIBUTION ITEMS
DIMENSION=[string, Needed]
DISTRIBUTION=[string, Needed]
ITEM=[string, Multiple, Needed]
CREATE=[boolean, default=false]
DATEOFFSET=[integer, default=0]
EDITITEMS=[boolean, default=false]
FIELDSEPARATOR=[string, default=Tabulator, values=[Circumflex,Comma,Semicolon,Tabulator,Pipe]]