1. Item SelectorYes

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.

2. Reference CategoriesYes

A list of items that will be used as Reference Categories in the report. Each item can be a combination of members from the dimensions associated with the list (usually Category, Year and/or Period. Formulas are not allowed

3. Enable Breakdown SelectionYes

This parameter specifies whether the end-user is able to select the breakdown dimension. If “Enable breakdown selection” is set to “Yes” then an additional breakdown selector should be shown to the end-user. The breakdown selector contains all possible breakdown dimensions for the current account.

4. Default Selected ItemNo

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

5. Side TrendYes

List of items that determines the X-axis of the trend in the side-controls (usually associated with the Year and the Period dimension).

6. Label Base CategoryYes

Dynamic Label that can combine the description of dimension-members and free text. The member-description can be obtained by putting the 3-character dimension abbreviation between square brackets (e.g., [CAT] for the Category dimension). Note: When using free text, don't use the "[" or "]" characters as these are reserved for Dynamic Label Expressions.

7. Breakdown ByYes

With this parameter you can select the dimension for which you want to see the descendants at the right-side or bottom of the report. In case of the Waterfall-chart it determines the nature of the movements or variance components. In case of the Ranking template it shows the ranking dimension.

8. Base / DirectYes

Select Base if you want to see the base-members (or leaf-members) under a certain parent-node (parent Entity, Product group, etc.). Choose Direct if you want to see the direct descendants (1st generation child-members).

9. Label DifferenceYes

In a Waterfall chart, the sum of the movements or variance components sometimes does 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.

10. Zoomed ViewYes

Select Yes if you want to open the report in a zoomed view. A zoomed view is a view in which only the relevant part of the scale is shown, in order to increase the readability of the chart.

11. Default Selected VarianceYes

Enter "Variance %" if you want to open a report with a variance percentage column. Enter "Variance" if you want absolute variance to be displayed by default.

12. Variance ThresholdYes

Threshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than the 1st threshold value, then Red (indicating an unfavorable variance) is used. If the Variance is greater than the 2nd threshold value, then Green (favorable variance) is used. And if Variance is between the 2 threshold values, Orange (neutral variance) is used. Use, for example, -200;300 for absolute thresholds or -10%;20% for relative thresholds.

13. Maximum ItemsYes

Maximum number of movements shown. The remainder is cumulated in an "Other" category (see parameter "Label Difference").

14. Reference Category PositionYes

Select the position of the Reference Category (e.g. "Budget")