Table Control
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 |
|---|---|---|
| This list defines the rows the report. This list influences most of the look and feel of the report. All list formatting options are supported. | Yes |
| 2. Columns | 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. Title | Defines the table title | No | Â |
4. Default Selected Row | Indicates the Row from the List that will be selected / highlighted upon opening of the report | No | Â |
5. External Item Selector | An external control that will be used as an item selector for this control | No | Â |
6. 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 | Â |
7. Default Selected Item | Indicates the Item from the List that will be selected / highlighted upon opening of the report | No | Â |
8. Merge Column Headers | If Yes: Column-headers with common dimension members will be merged (from left to right) | Yes | Â |
9. Fixed 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) This is the same as in a Multi Column report How can I fix the headers? | No | Â |
10. Maximum Label Column-Width | Maximum number of pixels reserved for the column with member-descriptions. | Yes | Â |
11. Member Description Position | Determines the column-position of the dimension member-descriptions. 0 means that the descriptions are at the leftmost position. | Yes | Â |
12. 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 | Â |
13. Scale | This defines the scaling used in the report. It can be overruled by the scaling in the List. | Yes | Â |
14. Precision | Defines the number of decimals used for presenting the number. Options are 0-6. Similar to the Scale setting, The Precision setting is the default for all data in the report, but can be overruled by a specific (not -1) precision in the List. | Yes | Â |
15. Variance Style | The variance style has the following options: Arrow, Background, Bar, BarAndValue, Border, Font, None, TrafficLight, TrendArrow | Yes | Â |
16. Replace Blanks By | Enter a character or string that you want to see instead of missing values. | No | Â |
17. Use Inline Drill | Provides an option to use inline drill for Rows List members. | Yes |  |
18. Exclude From Merge | Please specify the dimensions which should be excluded from the column merge in case of using the Multi Layer algorithm. The dimensions should be specified as the list of semicolumn delimited values (e.g. "ENR;ACC;YER") | No | Â |
19. Text Appearance | Select an option to respectively select it's font-size and padding. | No | Â |
20. Allow POV Change | Specify if you want to allow the clicks in the table to change the POV. This setting will be ignored if you don't enable the clickable charts or rows | Yes | Â |