Show Formula Items

Shows the items and sums of a formula.

Permissions

Command Kind	Needed User Kind
Read	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
Invisibles	boolean	If 'True' invisible items are shown. The default value is 'False'.	no	true
SumsOnly	boolean	If 'True' only sums are shown. The default value is 'False'.	no	false
Subtree	string	Name of the subtree ([Subtree]). A subtree is a flat extract of items and sums of the tree.	no

Result

Name	Type	Description
Type	string	Type of the item: Item or Sum.
Name	string	Name of the formula.
Caption1	string	Caption 1
Caption2	string	Caption 2
Caption3	string	Caption 3
Caption4	string	Caption 4
Caption5	string	Caption 5
Caption6	string	Caption 6
Caption7	string	Caption 7
Caption8	string	Caption 8
Caption9	string	Caption 9
Caption10	string	Caption 10
Attributes	string	List of the dimension item attributes.
Rubric	string	Rubric of the formula item.
Factor	number	Factor of the formula item.
Invisible	boolean	If 'True' the item is invisible.
Input	string	Input for the KPI function of a sum.

Code

SHOW FORMULA ITEMS
DIMENSION=[string, Needed]
FORMULA=[string, Needed]
INVISIBLES=[boolean, default=true]
SUMSONLY=[boolean, default=false]
SUBTREE=[string]