Rows

Default Selected Row

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

No

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 /wiki/spaces/CXO62/pages/105733578 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 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

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) 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. Title

Defines the table title

No

Scale

This defines the /wiki/spaces/CXO62/pages/105733627 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

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

Allow POV Change

Yes

Use Inline Drill

Provides an option to use inline drill for Rows List members.

Yes 

Text Appearance

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

No