Chart List

Introduction

The chart list is a list building block that can be used to define the charts for formatted statements like Multiple Bar & Line Charts reports. 

Example:

Depending on the list dimension chosen for a specific list, the first column(s) will be the dimension(s) which is chosen for each item. In the example above, that are the Entity and Account dimensions.

List Attributes

The Attributes are listed below.

Attributes

List Attribute

Description

Available

Values

Default
OrderUse the order attribute to reorder the rows.1, 2, 3...Max + 1
Item LabelThe default name of the item is displayed.n/an/a
Dimension1 ...Dimension nA column for each of the dimension on which the list is created. A member or a variable can be selectedMember or a Variablen/a
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
FormulaBy specifying a formula this line will be calculated.Empty, PopulatedEmpty
Parent ItemOlny relevant for Lists used in POV and in Value Tree LisEmpty, PopulatedEmpty

Format

The format 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 format, 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
Insert Data LabelUse this filed to determine whether the item value will be displayed. Relevant for chart reports only.Yes/No No
WidthDetermines the width of a cloumnEmpty, PopulatedEmpty
Item TypeDetermines the Type of the ItemLable Only, Data, CommantData
ValuationThe value of the valuation is inherited from the underlying system.Positive, Negativen/a

Reverse Sign

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

No, YesNo
VisibleThis value determines whether a column will be visible in the report.Yes/No Yes

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