Bridge Control

Introduction

Bridge controls can be used as chart on in the Free Format Template and are used to analyze the variance between two periods or categories for an account. The variances are analyzed over a specific Dimension which is normally the entity dimension or an analytical dimension. The variances are sorted on their absolute values from the highest variance to the smallest variance.

CONTENT

 

Parameters

The report parameters define the look & feel and behavior of a report.

Basic Template Parameters

Parameter

 

Description

Mandatory

Title

Title of the Bridge

No

Begin and EndSelect a List containing the Dimension-Members for the Start/Reference and the End/Base of the Bridge (e.g. Budget and Actual)Yes
Movements Select a List which contains the Bridge movement values for the calculation of the Movements that explain the difference between Base and Reference (e.g., Child-Entities, Products, Sub-Accounts). The Movements-list can also be a dynamic list. The sum of the Movements (Main Entity, Product Group, Main Account) should be specified in the Dimension Settings of the Report or in an Item Selector connected to the Bridge to insure the movements equal the difference between Base and Reference.Yes

Advanced Template Parameters

Parameter

Description

Mandatory

Calculate Movements

Specify if the movement of the bridge should be calculated .When the movements are not calculated the values shown will be retrieved from the data

Yes

External Item Selector

An external control that will be used as an item selector for this control.

No

Use Variance Coloring

Use different colors for positive and negative movements

No

Breakdown Sorting

Allows the control and sort sequence of variances. Select the appropriate option from the predefined list.

Yes

Label Difference

In a Bridge chart, the sum of the movements or variance components sometimes do not exactly explain the difference between the current period and a previous period or between Actual and Budget (e.g., due to Intercompany transactions). The remainder is put in an Other category. With this parameter we can label this Other category.

Yes

Zoomed View

Select Yes if you want to open the report in a zoomed view.

Yes

Show Gridlines

Select Yes if you want to show Gridlines.

Yes

Orientation

Select Horizontal (Bridge item labels on X-axis) or Vertical (Bridge item labels on Y-axis).

Yes

Labels Format

Select the format for the axis labels can be chosen from the Format list

Yes

Data Label Format

A format for the data labels can be chosen from the Format list

Yes

Labels Intersect ActionSelect an action to be done in order to prevent overlapping of the X-axis labels (MultipleRows, None, Rotate, Wrap).Yes

Rotate Labels

If Labels Intersect Action is set to Rotate, then select the desired orientation for the labels.Yes

Scale

This defines the scaling used in the report. It can be overruled by the scaling in the Lists.

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

Show Other

Show the "Other" Movements explained in 5. Label Difference or not

Yes

Hide Y axis

Set to Yes if you do not want Y axis numbers to be displayed on the chart

Yes

Allow POV Change

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

Yes

See Also

Free Format Template