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
Basic Attributes
List Attribute | Description | Available Values | Default |
|---|
Description
Empty
No
Empty lines will not be visible, if you set this attribute to yes.
Visible
Yes
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.
Custom Description
Empty
The custom description overrides the default generated name. You can use either a fixed text or a Dynamic Label Expression
Formula
Empty
By specifying a formula this period will be calculated.
Order
Max + 1
| 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 |