Example:
Depending on the list dimension chosen for a specific list, one of the first column(s) will be the dimension(s) which is chosen for each item. In the example above, that is the Account dimension, those are Category, Year, Version, Measure, Period and View dimensions.
List Attributes
In this The List of attributes the basic and advanced attributes are listedis listed below. 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.
BasicAttributes
List Attribute | Description | Available |
|---|
Custom Description
The custom description overrides the default generated column header. You can use either a fixed text or a Dynamic Label Expression. Use the <BR> tag for a line break.
Values | Default |
|---|
Empty
By setting this attribute to yes, the column will be shown as empty. This means that no data will be queried and only the label/custom description will be showed.
Visible
By setting this attribute to no, the column will be hidden. Hiding a column can be useful for a calculation step in a formula.
Order | Use the order attribute to reorder the columns. | 1, 2, 3, ... | Max + 1 |
| Item Label | The default name of the item is displayed. | n/a | 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 | Only relevant for Lists used in POV and in Value Tree List | Empty, Populated | Empty |
Format | The /wiki/spaces/CXO/pages/2806776298 attribute will |
specify the look and feel of the column. |
Width
The width defines the column width in pixels. If you want to leave the sizing to to the report specify 0.
Order
Use the order attribute to reorder the columns.
Advanced Attributes
List Attribute
Default
Description
Header Format
Reverse Sign
No
This format is not applied to the header of the column, but only to its values. | Default, Default_bold, Default_left, ... | Default Format |
Header | The header /wiki/spaces/CXO/pages/2806776298, defines how the column header should be formatted. The available values are identical with the ones used by the "Format" attribute, but applied only on the column header. | Default, Default_left, 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.
| 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 column | Empty, Populated | Empty |
| Item Type | Determines the Type of the Item | Label Only, Data, Comment | Data |
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 |
Variance Threshold
Empty
None, SuppressNoData, SuppressZeros, SuppressNoDataAndZeros | None | |
Suppress Variance |
SuppressNoBaseOrReference
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 |