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 are the Entity and Account dimensiondimensions.
List Attributes
In this List of attributes the basic and advanced attributes are listed. Additionally, if any values are available for the attribute, a direct link to an example on how this value affects the preview of the report is listed.
BasicThe Attributes are listed below.
Attributes
List Attribute | Description | Available Values | Default | |
|---|---|---|---|---|
List Attribute | Description | Available Values | Default | |
Empty | By setting this attribute to yes, the line will be shown as empty. This means that no data will be queried and only the label/custom description will be showed. | No, Yes | No | |
| Comment | By enabling the comment option, the end user can add custom comments on the whole row. | No, Yes | No | |
Visible | By setting this attribute to no, the line will be hidden. Hiding a line 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 | |
| Name | The default name of the item is displayed. | n/a | n/a | |
Formula | By specifying a formula this line will be calculated. | Empty, Populated | Empty | |
Format | The format will 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 | |
| Dimension1 ...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 | Olny relevant for Lists used in POV and in Value Tree Lis | Empty, Populated | Empty | |
Format | The format attribute will specify the look and feel of the row. | Millions_1, Thousands_1, ..... | n/a | |
Order | Use the order attribute to reorder the bars or lines. | 1, 2, 3... | Max + 1 |
Advanced Attributes
To access the advanced attributes, the Advanced button marked on the image above should be selected.
Header Format | The header 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 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_ | sumbold, Default | boldHighlighted 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 coloring. | 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 | Lable Only, Data, Commant | Data | ||||
| Valuation | The value of the valuation is inherited from the underlying system | and cannot be directly changed. | N/A | N/APositive, Negative | 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 column will be visible in the report. | Yes/No | Yes | ||||
Suppress Value | This value sets automatic column row suppressing, click on the the type to to see the suppressing options. | None, SuppressNoData, SuppressZeros, SuppressNoDataAndZeros | None | Variance Threshold | 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. | Empty, Populated | Empty |
Suppress Variance | Allows you to set the conditions for not suppressing the Variance, by using a a pick list | SuppressNoBaseOrReference, Suppress, NoSuppress, SuppressNoBase, SuppressNoReference | SuppressNoBaseOrReference | ||||
| Insert Data Label in Chart | When this attribute is set to yes, the data label will be displayed next to the respective bar or line | No, Yes | NoRedirect Report | Use this field to select an existing report that will be available through a hyperlink. | Empty, Populated | Empty |