Show Tree Sum Items

Shows the assigned items and sums of a tree sum. Only the next level is show.

Permissions

Command Kind	Needed User Kind
Read	All

Parameters

Name	Type	Description	Required	Default	Values
Dimension	string	Name of the dimension ([Dimension]).	yes
Sum	string	Name of the tree sum ([Sum]).	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

Result

Name	Type	Description
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 SUM ITEMS
DIMENSION=[string, Needed]
SUM=[string, Needed]
TREE=[string, Needed]