Parameters
The report parameters define the look & feel and behaviour of a report. On the screenshot below you can see the parameters numbers. These numbers refer to the parameters as displayed in the Basic Parameters and Advanced Parameters table. Next to basic and advanced parameters there are also /wiki/spaces/CXO62/pages/105733577
Basic Parameters
| Parameter | Description | Mandatory |
|---|---|---|
| 1. Right Y - axis items | 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. | Yes |
| 2. Reference Categories | 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. | Yes |
Advanced Parameters
Parameter | Description | Mandatory |
|---|---|---|
3. Left Y-Axis label | Dynamic Label that can combine the description of dimension-members and free text. The member-description can be obtained by putting the 3-digit dimension abbreviation between square brackets (e.g., [CAT] for the Category dimension). Don't use the [ or ] character in free text. | Mandatory |
4. Time Series | List of items that determines the X-axis of the chart; usually a Time-series associated with the Year and the Period dimension. | Mandatory |
5. Label Base Category | Dynamic Label that can combine the description of dimension-members and free text. The member-description can be obtained by putting the 3-digit dimension abbreviation between square brackets (e.g., [CAT] for the Category dimension). Don't use the [ or ] character in free text. | Mandatory |
6. Reverse Sign | In some HFM/Enterprise applications, costs are input as a negative income. By default, a graph would also show negative values, which makes the graphs less intuitive. The CXO-Cockpit therefore allows for reversing the sign for the purpose of showing such costs as positive values. The financial intelligence (evaluation of green/red) remains intact. | Mandatory |
7. Breakdown Sorting | Allows the control and sort sequence of variances. Select the appropriate option from the pre defined list. | Mandatory |
8. 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 unfavorable variance) or Green (favorable variance) is used. Use e.g. -200;300 for an absolute threshold or -10%;20% for a relative threshold | Mandatory |
9. Scale Main Account (denominator) | This defines the scaling used in the main account (denominator) it overrides the scaling for the report. Options are: Millions, Thousands, Unchanged (no scaling), Percentage. The last option multiplies the amount with 100 to show for example an amount of 0.75 from HFM/Enterprise as ‘75%’ in the CXO-Cockpit. | Mandatory |
10. Precision Main Account (denominator) | This defines the number of decimals used for presenting the numbers for the main account (denominator). It overrides the precision set for the report. Options are 0-6. | Mandatory |
See Also
Functional end-user description of template:Compare Trend