- End of Last Year
- Budget
- Last Month
etc.
Example:
List Attributes
List Attribute | Description | Available Values | Default | ||||
---|---|---|---|---|---|---|---|
Order | Use the order attribute to reorder the rows. | 1, 2, 3... | Max + 1 | ||||
NameItem Label | The default name of the item is displayed. | n/a | n/a | Formula | By specifying a formula this line will be calculated. | Empty, Populated | |
EmptyDimension1 ...Dimension n | A column for each of the dimension on which the list is created. A member or a variable can be selected | Member or a Variable | 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 /wiki/spaces/CXO/pages/2806776298format 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/2806776298format, 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.Relevant for chart reports only. | Yes/No | No | ||||
Width | Determines the width of a cloumn | Empty, Populated | Empty | ||||
Item Type | Displayes the Type of the Item | No DataLabel Only, Data, Commant | Data | Valuation | The value of the valuation is inherited from the underlying system and cannot be directly changed. | n/a | n/a |
Reverse Sign | When this attribute is set to yes, the sign will be flipped. | No, Yes | No | ||||
Visible | This value determines whether a item 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 Report | Use this field to select an existing report that will be available through a hyperlink. | Empty, Populated | Empty |