Versions Compared

Key

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

Introduction

A time series list is a list building block that can be used for the X axis of charts that show/compare periods. Since most reports use a chart with time series, this parameter type occurs on most reports. The parameter ´time series list´ is considered as an advanced parameter because it normally it can be left to default. Typical examples for a time ´time series list´ are:

  • Last 6 months (dynamic list based on @@CUR, @@CUR-1, etc.)
  • Last 12 months
  • Current year (Fixed list with members like Jan, Feb, etc.)

CONTENT

Table of Contents

Most used dimensions for a ´time series list´ are Period and Year, but also dimensions like scenario and view can be used in a ´time series list´.

 

Example:

 

Image RemovedImage Added

List Attributes

Basic

Attributes

List Attribute

DescriptionAvailable Values

Default

Empty

Empty lines will not be visible, if you set this attribute to yes.

No, Yes

No

Visible

By setting this attribute to no, the period will be hidden. Hiding a period can be useful when used as a calculation step in a formula.

Yes, No

Yes

Custom Description

The custom description overrides the default generated name. You can use either a fixed text or a Dynamic Label Expression

Empty, Populated

Empty

Formula

By specifying a formula this period will be calculated.

Empty, Populated

Empty

Order

 Use the order attribute to reorder the time series.1, 2, 3, ...Max + 1OrderUse 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

Format

The /wiki/spaces/CXO/pages/2806776298 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/CXO/pages/2806776298, 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
Label Yes/No No
Width Empty, PopulatedEmpty
Item TypeDisplayes the Type of the ItemNo Data, 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