Basic Template ParametersParameter
Content Settings
Settings |
|---|
|
|---|
No
| Description | Mandatory |
|---|---|
| Begin and End |
| Select |
| a List containing the Dimension-Members for the Start/Reference and the End/Base of the Bridge (e.g. Budget and Actual) |
| Yes | ||
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 |
| 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 |
Advanced Template Parameters
Parameter
Mandatory
Description
4. Calculate Movements
Yes
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
5. External Item Selector
No
An external control that will be used as an item selector for this control.
6. Use Variance Coloring
No
Use different colors for positive and negative movements
7. Breakdown Sorting
Yes
Allows the control and sort sequence of variances. Select the appropriate option from the predefined list.
8. Label Difference
Yes
| to insure the movements equal the difference between Base and Reference. | Yes |
Labels, Formats and Colors Settings
Settings | Description | Mandatory |
|---|---|---|
Title | Title of the Bridge | No |
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 |
9. Zoomed View
Yes
. |
10. Show Gridlines
Yes |
11. Orientation
Yes
Select Vertical or Horizontal.
Labels Format |
Yes
Select the format for the axis labels can be chosen from the /wiki/spaces/CXO/pages/2806776298 list |
Yes |
Data Label Format |
Yes
A format for the data labels can be chosen from the /wiki/spaces/CXO/pages/2806776298 list |
14. Scale
Yes | ||
| Labels Intersect Action | Select 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 /wiki/spaces/CXO/pages/2806776400 used in the report. It can be overruled by the scaling in the |
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 Settings
Settings | Description | Mandatory |
|---|---|---|
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 |
Other Settings
| Settings | Description | Mandatory |
|---|---|---|
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 |
Show Other | Show the "Other" Movements explained in 5. Label Difference or not |
Yes |
Hide Y axis |
Yes
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 |
Subtotals in Bridge
There is the option to create a subtotal in the bridge.
Set the Item Type in the movement list to Subtotal
Next thing is to set the start of the subtotal to determine where the bar of the bridge should start counting of.
See Also
Free Format TemplateReport