Multi-Column Template
Basic Parameters
| Parameter | Description | Mandatory |
|---|---|---|
1. Rows | This list defines the rows of the report. This list influences most of the look and feel of the report. All list formatting options are supported. | Yes |
| 2. Columns | Mandatory | A list of items that will be used as columns in the report. Each item can be a combination of members from the dimensions associated with the list (usually Category, Year and/or Period). | Yes |
Advanced Parameters
Parameter | Description | Mandatory |
|---|---|---|
3. Item Selector | 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. | No |
4. Default Selected Item | Indicates the Item from the List that will be selected / highlighted upon opening of the report | No |
5. Merge Column Headers | If Yes: Column-headers with common dimension members will be merged (from left to right), using one of the selected methods either single , multi layer or none | Yes |
6. Freeze Headers | When the report exceeds the available space on the screen, freeze either the Column headers so that when the user scrolls down the page the Column headers are maintained so that they can be read properly. When freezing rows they will only be frozen when the row member description is in column 0 ( see Member Description Position below) | Yes |
7. Palette | Color Palette allows you to customize colors displayed in a report. | Yes |
8. Replace Blanks By | Enter a character or string that you want to see instead of missing values. | No |
9. Use Inline Drill | Provides an option to use inline drill for Rows List members. | Yes |
10. Exclude From Merge | Specify the dimensions which should be excluded from the column merge (see above) when using the Multi Layer Algorithm. The dimensions should be specified in a list with semi colons to delimit the values eg ENT;ACC;YER | No |
11. Maximum Label Column-Width | Maximum number of pixels reserved for the column with member-descriptions. | Yes |
12. Member Description Position | Determines the column-position of the dimension member-descriptions. 0 means that the descriptions are at the leftmost position and 7 means that it comes after the 7th column, in 8th position. | Yes |
13. 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 | Yes |
14. Variance Style | The variance style has the following options: Arrow, Background, Bar, BarAndValue, Border, Font, None, Traffic Light, TrendArrow | Yes |
See Also
Functional end-user description of template:Multi-Column