Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

A Value Tree List list is a list building block that can be used for value tree statements. This type of list contains attributes for positioning of the blocks and is used for Value Tree Reports.

CONTENT

Table of Contents

Example:

 

List Attributes

List Attribute

Description

Available Values

Default

OrderUse the order attribute to reorder the rows.1, 2, 3...Max + 1
NameThe default name of the item is displayed.n/an/a
FormulaBy specifying a formula this line will be calculated.Empty, PopulatedEmpty
DrillBy assigning a drill list to a row, a drill icon will appear in front of the line in the report. This drill list allows the end-user to drill to that list. If a dimension member of an item is a parent in the dimension hierarchy then the end user can also assign a dynamic drill to an item instead of another list.Empty, PopulatedEmpty

X Coordinate

The X coordinate defines the position of the tree member on the X Axis, see screenshot for the X positions.

0, 1, 2, 3, ...

0

Y Coordinate

The Y coordinate defines the position of the tree member on the Y Axis, see screenshot for the Y positions.

0, 1, 2, 3, ...

0

Unary Operator

The unary operator defines the symbol (See screenshot) in front of each tree member.

+, -, /, *

+

Parent Item

Select a /wiki/spaces/CXO60/pages/43811337 so that the tree member will be connected with a line to the parent tree member.

Empty, Populated

Empty

Format

The /wiki/spaces/CXO60/pages/43811292 attribute will specify the look and feel of the row. This format is not applied to the header of the row, but only to its values.

Default, Default_bold, Default_left, ...Default

Header

The header /wiki/spaces/CXO60/pages/43811292, defines how the row header should be formatted. The available values are identical with the ones used by the "Format" attribute, but applied only on the row header.

Default, Default_bold, Default Highlighted Header, ...Default Format
LabelUse this filed to determine whether the item value will be displayedYes/No No
WidthDetermines the width of a cloumnEmpty, PopulatedEmpty
Item TypeDisplayes the Type of the ItemNo DataLabel Only, Data, CommantData
ValuationThe value of the valuation is inherited from the underlying system and cannot be directly changed.n/an/a

Reverse Sign

When this attribute is set to yes, the sign will be flipped.

No, YesNo

Suppress Value

This value sets automatic row suppressing, click on the type to see the suppressing options.

None, SuppressNoData, SuppressZeros,

SuppressNoDataAndZeros

None

Suppress Variance

Allows you to set the conditions for not suppressing the Variance, by using a pick list

SuppressNoBaseOrReference,

Suppress, NoSuppress, SuppressNoBase,

SuppressNoReference

SuppressNoBaseOrReference
Redirect ReportUse this field to select an existing report that will be available through a hyperlink.Empty, PopulatedEmpty

Note: When you redirect to a report of type Multi-Column and that report has the same Value Tree List as an Item Selector, the Multi-Column report will automatically select the tree member where it was redirected from.