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 | ||||||
| Name | The default name of the item is displayed. | n/a | No | Visiblen/a | |||||
| Formula | By | setting this attribute to no, thespecifying a formula this 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 Expression | Empty, Populated | Empty | ||||||
Formula | By specifying a formula this item will be calculatedcalculated. | Empty, Populated | Empty | ||||||
| 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 | ||||||
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 |
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 | 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 | NoFormat |
| Label | Yes/No | No | |||||||
| Width | Empty, Populated | Empty | |||||||
| Item Type | Displayes the Type of the Item | No Data, 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 | ||||||
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 thresholdSuppress Value | This value sets automatic row suppressing, click on the type to see the suppressing options. | None | ||||||
Suppress Variance | Allows you to set the conditions for not suppressing the Variance, by using a pick list | SuppressNoBaseOrReference | |||||||
| Redirect Report | Use this field to select an existing report that will be available through a hyperlink. | Empty, Populated | Empty |