Parameters
The report parameters define the look & feel and behavior of a report.
Basic Template Parameters
Parameter
| Mandatory | Description |
|---|---|---|
1. Title | No | Title of the Bridge |
| 2. Begin and End | Yes | Select The List containing the Dimension-Members for the Start and the End of the Bridge (e.g. Budget and Actual) |
| 3. Movements | Yes | Select a list which contains the Bridge Movements (e.g., Child-Entities, Products, Sub-Accounts). 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. The Movements-list can also be a dynamic list. |
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 | 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 | Select Yes if you want to open the report in a zoomed view. |
10. Show Gridlines | Yes | Select Yes if you want to show Gridlines. |
11. Orientation | Yes | Select Vertical or Horizontal. |
12. Labels Format | Yes | Select the format for the axis labels can be chosen from the /wiki/spaces/CXO/pages/2806776298 list
|
13. Data Label Format | Yes | A format for the data labels can be chosen from the /wiki/spaces/CXO/pages/2806776298 list
|
14. Scale | Yes | This defines the /wiki/spaces/CXO/pages/2806776400 used in the report. It can be overruled by the scaling in the List. |
15. Precision | Yes | 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. |
16. Show Other | Yes | Show the "Other" Movements explained in 5. Label Difference or not |
17. Hide Y axis | Yes | Set to Yes if you do not want Y axis numbers to be displayed on the chart |
18. Allow POV Change | Yes | 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. |