A report to analyse working capital is a good example of how to use this template. You will be able to see the development of working capital as a whole and the contribution of the different components to it.
Parameters
The report parameters define the look & feel and behavior 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 Basic and advanced parameters Advanced Parameters there are also /wiki/spaces/CXO/pages/2806776440
Basic Parameters
Parameter | Description | Mandatory |
---|---|---|
1. Component Items | A list of items that determines the Components of the chart. Each item can be a combination of members from the dimensions associated with the list or a formula (based on other items in the list). | 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. Default Selected Item | Indicates the Item from the Components List that will be selected / highlighted in the Side Trend upon opening of the report. If none is selected, the 1st item will be selected. | No |
4. Side Trend | List of items that determines the X-axis of the trend in the Side Trend control (usually associated with the Year and the Period dimension). | Yes |
5. Total | 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. | Yes |
6. 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. | Yes |
7. 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-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. | Yes |
8. Remainder | When an account is broken up into components, sometimes not all components are listed. The remainder can be grouped as a separate component with its own label. | No |
9. Reverse Sign | In some underlying systems, 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. | Yes |
10. Breakdown Sorting | Allows to control and sort sequence of variances. Select the appropriate option from the predefined list, e.g. best variance on top, worst on top, e.g. | Yes |
11. Variance Threshold | 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. | Yes |
See Also
Functional end-user description of template:Portfolio