Table Control

Owned by Migration
Last updated: Apr 19, 2016 by Nadica Gaber (Unlicensed)
3 min read

Introduction

Table controls can be used as object on in the Free Format Report. If you want to determine a table with a flexible number of columns and rows then, we recommend you to use the table control.

A table control can also be used to define a Multi Source.

CONTENT

Settings

The report settings  define the look & feel and behaviour of a report. 

Content Settings

Settings

DescriptionMandatory

Rows

This list defines the rows the report. This list influences most of the look and feel of the report. All list formatting options are supported.Yes

Default Selected Row

Indicates the Row from the List that will be selected / highlighted upon opening of the report

No

ColumnsA list of items that will be used as columns in the report. Each item can be a combination of members from the dimensions associated with the list (usually Category, Year and/or Period).Yes

Item Selector

A list of items that will be used as a Pick List in the report. Each item can be a combination of members from the dimensions associated with the list. Usually, the Account dimension is used.

No

Default Selected Item

Indicates the /wiki/spaces/CXO63/pages/109218288 from the List that will be selected / highlighted upon opening of the report

No

Labels Formats and Colors

SettingsDescriptionMandatory

Merge Column Headers

If Yes: Column-headers with common dimension members will be merged (from left to right)

Yes

Exclude From Merge

Please specify the dimensions which should be excluded from the column merge in case of using the Multi Layer algorithm. The dimensions should be specified as the list of semicolumn delimited values (e.g. "ENR;ACC;YER")

No

Freeze Headers

When the report exceeds the available space on the screen, freeze either the Column headers so that when the user scrolls down the page the Column headers are maintained so that they can be read properly. When freezing rows they will only be frozen when the row member description is in column 0 ( see Member Description Position below) This is the same as in a Multi Column report How can I fix the headers?

No

Member Description Position

Determines the column-position of the dimension member-descriptions. 0 means that the descriptions are at the leftmost position.

Yes

Label Column WidthThe width of the Label Column 

Title

Defines the table title

No

Scale

This defines the /wiki/spaces/CXO63/pages/109218247 used in the report. It can be overruled by the scaling in the List.

Yes

Precision

Defines the number of decimals used for presenting the number. Options are 0-6. Similar to the Scale setting, The Precision setting is the default for all data in the report, but can be overruled by a specific (not -1) precision in the List.

Yes

Variance

SettingsDescriptionMandatory

Variance Style

The variance style has the following options: Arrow, Background, Bar, BarAndValue, Border, Font, None, TrafficLight, TrendArrow

Yes

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 unfavourable variance) or Green (favourable variance) is used. Use e.g. -200;300 for an absolute threshold or -10%;20% for a relative threshold

Yes

Other

SettingsDescriptionMandatory

Allow POV Change

Specify if you want to allow the clicks in the table to change the POV. This setting will be ignored if you don't enable the clickable charts or rows

Yes

Use Inline Drill

Provides an option to use inline drill for Rows List members.

Yes

Text Appearance

Select an option to respectively select it's font-size and padding.

No