3. Title

Not Mandatory

Defines the table title

No

4. Default Selected RowNot Mandatory

Indicates the Row from the List that will be selected / highlighted upon opening of the report

No

5. External Item SelectorNot Mandatory

An external control that will be used as an item selector for this control

No

6. Item Selector

Not Mandatory

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 ItemNot Mandatory

Indicates the /wiki/spaces/CXO60/pages/43811337 from the List that will be selected / highlighted upon opening of the report

No

8. Merge Column Headers

Mandatory

If Yes: Column-headers with common dimension members will be merged (from left to right)

Yes

9. Fixed HeadersNot Mandatory

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-WidthMandatory

Maximum number of pixels reserved for the column with member-descriptions.

Yes

11. Member Description Position

Mandatory

Determines the column-position of the dimension member-descriptions. 0 means that the descriptions are at the leftmost position.

Yes

12. Variance Threshold

Mandatory

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. ScaleMandatory

This defines the /wiki/spaces/CXO60/pages/43811287 used in the report. It can be overruled by the scaling in the List.

Yes

14. PrecisionMandatory

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 StyleMandatory

The /wiki/spaces/CXO60/pages/43810989 has the following options: Background, Bar, Border, Box, Font, None, TrafficLight, TrendArrow

Yes

16. Replace Blanks By

Not Mandatory

A character or a string which will be put instead of the missing value.

No

17. Use Inline DrillMandatory

Select Yes if you want to enable Inline Drill

Yes

18. Exclude From MergeNot Mandatory

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 AppearanceNot Mandatory

Select an option to respectively select it's font-size and padding.

No

20. Allow POV ChangeMandatory

Yes