Skip to content

Create Formula Item ​

Adds an item to a formula.

Permissions ​

Command KindNeeded User Kind
WriteAll

Parameters ​

NameTypeDescriptionRequiredDefaultValues
DimensionstringName of the dimension ([Dimension]).yes
FormulastringName 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
Itemarray of stringAdds an item to a formula ([Item].[Rubric].[Factor].[Invisible]), e.g. [800000].[Turnover].[1].[False].yes

Result ​

No fields

Code ​

text
CREATE FORMULA ITEM
DIMENSION=[string, Needed]
FORMULA=[string, Needed]
ITEM=[string, Multiple, Needed]