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 | DefaultAvailable | DescriptionValues | EmptyDefault | ||
|---|---|---|---|---|---|---|
No | Empty lines will not be visible, if you set this attribute to yes. | Comment | NoOrder | 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 | Visiblen/a | |||
| YesDrill | By setting this attribute to no, the line will be hidden. Hiding an item can be useful for 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 | 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 item line will be calculated. | Empty, Populated | Empty | |||
| Parent Item | Only relevant for Lists used in POV and in Value Tree List. | Empty, Populated | FormatEmpty | |||
Default Format | ||||||
List Attribute | Default | Description | ||||
Header Format | Default | The /wiki/spaces/CXO/pages/2806776298 can be used to override scaling and precision. | ||||
Order | Max + 1 | Use the order attribute to reorder the items. |
Advanced Attributes
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/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 Highlighted Header, ... | |
Reverse Valuation | No | 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 coloring. | |
Reverse Sign | NoDefault 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 | 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. | ||
Insert Data Label in Chart | No | When this attribute is set to yes, the data labels will be included into the chart | |
Variance Threshold | Empty | Threshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than this Threshold, then a neutral variance color is used (Orange). Otherwise Red (indicating an unfavorable variance) or Green (favorable variance) is used. Use e.g. -200;300 for an absolute threshold or -10%;20% for a relative threshold.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 |