Rows List
A rows list is a list building block that can be used for formatted statements. This type of list supports all types of formatting and is used for example on:
Example:
Depending on the list dimensions chosen for a specific list, the one of the data column(s) will be the dimension(s) which is chosen for each item. In the example above, that is the Account dimension.
List Attributes
The List of attributes is listed below.
Attributes
| List Attribute | Description |
Available Values |
Default |
|---|---|---|---|
| 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 column will be calculated. |
Empty, Populated | Empty |
| Parent Item | Olny relevant for Lists used in POV and in Value Tree List | Empty, Populated | Empty |
Format |
The format 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 format, 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 | 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 |
| Visible | This value determines whether a column will be visible in the report. | Yes/No | |
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 |
| Navigate to | Use this field to select an existing report that will be available through a hyperlink. | Empty, Populated | Empty |