Show Item Trees

Shows the trees where a dimension item is used.

Permissions

Command Kind	Needed User Kind
Read	All

Parameters

Name	Type	Description	Required	Default	Values
Dimension	string	Name of the dimension ([Dimension]).	yes
Brackets	boolean	If 'True' the trees are shown with brackets, e.g. [Products], [Region]. The default value is 'False'	no	false
Item	array of string	Name of the dimension item ([Item]).	no
Nulls	boolean	If 'True' items are hidden that are not used in any tree. The default value is 'False'.	no	false
Tree	array of 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	no

Result

Name	Type	Description
Item	string	Name of the dimension 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 attributes of the dimension item.
Trees	string	List of the trees where the dimension item is used.

Code

SHOW ITEM TREES
DIMENSION=[string, Needed]
BRACKETS=[boolean, default=false]
ITEM=[string, Multiple]
NULLS=[boolean, default=false]
TREE=[string, Multiple]