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

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:

List Attributes

List Attribute	Description	Available Values	Default
Order	Use the order attribute to reorder the rows.	1, 2, 3...	Max + 1
Item Label	The default name of the item is displayed.	n/a	n/a
Period	The period that is assigned to the item label	Current, Future, Previous periods, variables..	n/a
Drill	By 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, Populated	Empty
Formula	By specifying a formula this line will be calculated.	Empty, Populated	Empty
Parent Item	Only relevant for Lists used in POV and in Value Tree List.	Empty, Populated	Empty
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 Label	Use this filed to determine whether the item value will be displayed	Yes/No	No
Width	Determines the width of a cloumn	Empty, Populated	Empty
Item Type	Displayes the Type of the Item	Label Only, Data, Commant	Data
Reverse Sign	When this attribute is set to yes, the sign will be flipped.	No, Yes	No
Visible		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 Report	Use this field to select an existing report that will be available through a hyperlink.	Empty, Populated	Empty

Documentation

Time Series List

Introduction

Example:

List Attributes

Related pages