Skip to content

Show Formula Item

Shows an item or sum of a formula.

Permissions

Command KindNeeded User Kind
ReadAll

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
ItemstringItem or sum of a formula ([Item] or [Sum]).yes

Result

NameTypeDescription
TypestringType of the item: Item or Sum.
NamestringName of the formula item.
Caption1stringCaption 1
Caption2stringCaption 2
Caption3stringCaption 3
Caption4stringCaption 4
Caption5stringCaption 5
Caption6stringCaption 6
Caption7stringCaption 7
Caption8stringCaption 8
Caption9stringCaption 9
Caption10stringCaption 10
AttributesstringList of the dimension item attributes.
RubricstringRubric of the formula item.
FactornumberFactor of the formula item.
InvisiblebooleanIf 'True' the item is invisible.
InputstringInput for the KPI function of a sum.

Code

text
SHOW FORMULA ITEM
DIMENSION=[string, Needed]
FORMULA=[string, Needed]
ITEM=[string, Needed]