Columns List

Owned by Migration
Last updated: Dec 06, 2017 by Jeroen de Soeten (Unlicensed)
2 min read

Introduction

A columns list is a list building block that can be used to define the columns for formatted statements like Multi Column reports. This list allows you to format the columns exactly the way you want.

Note: Column formats override row formats. For example: your row is formatted to use scale:thousands and the column is formatted to use scale:percentage, the cell where the row and column cross will be formatted as percentage.

CONTENT

Example:

 

Depending on the list dimension chosen for a specific list, one of the column(s) will be the dimension(s) which is chosen for each item. In the example above, those are Category, Year, Version, Measure, Period and View dimensions.

List Attributes

The List of attributes is 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. 

 Attributes

List Attribute

Description

Available

Values

Default

Order

Use the order attribute to reorder the columns.

1, 2, 3, ...Max + 1
Item LabelThe default name of the item is displayed.n/an/a
DrillBy 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, PopulatedEmpty

Formula

By specifying a formula this column will be calculated.

Empty, PopulatedEmpty
Parent ItemOnly relevant for Lists used in POV and in Value Tree ListEmpty, PopulatedEmpty

Format

The /wiki/spaces/CXO63/pages/109218346 attribute will specify the look and feel of the column. 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/CXO63/pages/109218346, 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, ...Default Format
Insert Data LabelUse this filed to determine whether the item value will be displayed. Relevant for chart reports onlyYes/No No
WidthDetermines the width of a columnEmpty, PopulatedEmpty
Item TypeDetermines the Type of the ItemLabel Only, Data, CommentData

Reverse Sign

When this attribute is set to yes, the sign will be flipped

No, YesNo
VisibleThis value determines whether a column will be visible in the reportYes/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 ToUse this field to select an existing report that will be available through a hyperlink.Empty, PopulatedEmpty