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 and advanced parameters there are also Generic Report Parameters
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 pick list that will be selected / highlighted upon opening of the report | No |
4. Side Trend | List of items that determines the X-axis of the trend in the side-controls (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-digit dimension abbreviation between square brackets (e.g., [CAT] for the Category dimension). Don't use the [ or ] character in free text. | 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 this Threshold, then a neutral variance color is used (Orange). Otherwise Red (indicating an unfavourable variance) or Green (favourable variance) is used. Use e.g. -200;300 for an absolute threshold or -10%;20% for a relative threshold | Yes |
See Also
Functional end-user description of template:Portfolio