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 is the Account dimension.
List Attributes
Basic Attributes
List Attribute | Description | Available Values | Default | |||||
|---|---|---|---|---|---|---|---|---|
Empty | Empty lines will not be visible, if you set this attribute to yes. | No, Yes | No | |||||
| 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 | No|||||
| Drill | ||||||||
Visible | By setting this attribute to no, the line will be hidden. Hiding an item can be useful for 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 ExpressionBy 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 | itemline will be calculated. | Empty, Populated | Empty | ||||
| Parent Item | Only relevant for Lists used in POV and in Value Tree List. | Empty, Populated | Empty | |||||
Format | can be used to override scaling and precision | 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 Format | Order | Use the order attribute to reorder the items. | 1, 2, 3, ...Max + 1 |
Advanced Attributes
List Attribute | Description | Available Values | Default | |||
|---|---|---|---|---|---|---|
Header Format | The header /wiki/spaces/CXO/pages/2806776298, defines how the | column 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 | _leftHighlighted Header, ... | Default Format | |
Reverse Valuation | When this attribute is set to yes, the Valuation will be reversed. This means negative becomes positive and the other way around. Changing the valuation will influence the variance colouring. | No, Yes | NoInsert 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 | Determines the Type of the Item | Label Only, Data, Commant | Data | |||
| Valuation | The value of the valuation is inherited from the underlying system. | Positive, Negative | n/a | |||
Reverse Sign | When this attribute is set to yes, the sign will be flipped. | No, Yes | No | |||
Insert Data Label in Chart | When this attribute is set to yes, the data labels will be included into the chart | No, Yes | No | |||
Variance Threshold | Threshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than this Threshold, then a neutral variance colour is used (Orange). Otherwise Red (indicating an unfavourable variance) or Green (favourable variance) is used. Use e.g. -200;300 for an absolute threshold or -10%;20% for a relative thresholdVisible | 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 |