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]