Show Tree Items

Shows the dimension items and sums of a tree.

Permissions

Command Kind	Needed User Kind
Read	All

Parameters

Name	Type	Description	Required	Default	Values
Dimension	string	Name of the dimension ([Dimension]).	yes
Tree	string	Name of the tree ([Tree]). A tree is a hierarchical structure of a dimension. A tree is build of sums. These sums can contain other sums or elements of the dimension	yes
Invisibles	boolean	If 'True' invisible items or sums are shown. The default value is 'True'.	no	true
Level	integer	Max level to be shown. If it is '0' all levels are shown. The default value is '0'.	no	0
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
Level	integer	Level of the item or sum.
Type	string	Type of the tree item: Item or Sum.
Name	string	Name of the tree item.
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.
Factor	number	Factor of the tree item or sum.
TreeFactor	number	Cumulated factor from all parents of the item or sum.
Invisible	boolean	If 'True' the item or sum is invisible.
Kpi	string	Calculation of the tree sum KPI. The KPI consists of three parts separated by dot. The first part is a list of tree items and sums, which are added. The third part is also a list of tree items and sums, which are added. The second part is a mathematical operator for part one and three. It is the keyword for the parser: [None], ([Addition], [Add] or [+]), ([Subtraction], [Sub] or [-]), ([Multiplication], [Mul] or [*]), ([Division], [Div] or [/]), ([PercentDeviation], [Percent] or [%]), e.g. [Personnel Costs],[Material Costs],[Marketing costs].[%].[Turnover]
Builder	string	Function to build automatically tree sums.
BuilderSort	string	Sort order of the builder function: Name, Caption1, Caption2, Caption3, Caption4, Caption5, Caption6, Caption7, Caption8, Caption9 or Caption10.

Code

SHOW TREE ITEMS
DIMENSION=[string, Needed]
TREE=[string, Needed]
INVISIBLES=[boolean, default=true]
LEVEL=[integer, default=0]
SUMSONLY=[boolean, default=false]
SUBTREE=[string]