Miscellaneous settings

1. View

1.1. Visual context menu

When the Visual context menu option is enabled, a context menu is displayed by right-clicking a row.

Visual context menu

1.2. Header word wrap

When the Header Word Wrap option is enabled, the header content is wrapped according to the height of the cell. The image below shows how the headers are displayed when the header word wrap option is disabled.

Header word wrap disabled

You will be able to see the entire header when word wrap is enabled.

Header word wrap enabled

1.3. Quick shortcuts

This option lets you add quick shortcut icons in the Actions section. The Undo, Redo, Export as Excel, and Best Fit options are selected by default. You can select additional options including Export PDF, Aggregation, and Smart Analysis. The shortcuts for all the selected options will be displayed in the Actions section.

Quick shortcuts

1.4. Show info messages

You can disable this option if you do not wish to see pop-up notifications and info messages.

Show info messages

1.5. Absolute sort

Enabling this option will sort measures based on the magnitude, irrespective of whether a value is positive or negative.

Absolute sort disabled

Notice how the values are sorted based on magnitude when absolute sort is turned on.

Absolute sort enabled

1.6. Show measure header

The column or measure headers will hidden if this option is disabled.

Show measure header

1.7. Fiscal year start month

Inforiver supports planning, budgeting, and forecasting for fiscal periods as well. You can set the start month of the fiscal year using this option.

Fiscal year start month

1.8. Show floating toolbar

When the main toolbar has been unpinned, you will still be able to apply cell-level formatting, show/hide cell values, and add comments using the floating toolbar. Disable this option if you do not require the floating toolbar.

Show floating toolbar

1.9. Diagnose

This option can be enabled if you wish to mask your data and generate random values when the data is being shared and security is a concern.

1.10 Allow native measure editing in read view

If this option is enabled, report users in the reading view can update native measures.

1.11. Increase scroll thickness

You can increase the thickness of the horizontal and vertical scrollbars using by enabling this option.

Increase scroll thickness

1.12. Hide pinned base rows

Inforiver’s pin rows feature enables you to tag important rows in your data at the top of your report. Using this feature creates duplicate rows at the visual level (there is no change to your data). In the report below, notice how the pinned rows such as ‘Bookcases’ are repeated in the table below.

Hide base pinned rows disabled

You can enable the Hide pinned base rows option to hide the actual row and retain only the pinned rows.

Hide pinned base rows enabled

1.13. Language

Inforiver supports English (the default language) and German language interfaces. You can choose one of the options. In the image below, German is selected to change all the menus, tabs, and options to the German language.

German language interface

1.14. Right to left

Reports with RTL support improve the user experience for readers of RTL languages, making it easier for them to navigate, understand, and interpret the information presented. When the right-to-left option is enabled:

• Data is arranged from right to left, notice how the months are arranged from December to January.

• The row categories are displayed on the right-hand side.

• Toolbar options are arranged from right to left.

Right to left layout

2. Status bar

2.1. Show status bar

You can show/hide the status bar with this option. If this option is enabled, the Status Panel Aggregation option becomes available.

2.2. Status panel aggregation

The Status Panel Aggregation option allows you to show the aggregation such as sum, average, min, max, and count for the values selected in the visual. In the below example, you can see the sum, average, and count aggregation for the selected values/measure in the status bar.

Only a maximum of three aggregations are displayed in the status bar.

Status panel aggregation

3. Cell/row/column

3.1. Global error handling

Inforiver provides a global error handling setting that internally handles missing reference errors and converts the missing values to 0 when used in calculations.

Consider that you are deriving the standard deviation for beverages across EMEA and APAC regions.

Creating a calculated row

If EMEA data is not available, the calculation will still work seamlessly in the report without throwing errors.

Caculation works without errors when the setting is on

Notice how a missing reference error is displayed when the error handling setting is disabled.

Global error handling

3.2. Edit cell indicator

This option allows you to identify the edited/modified cell values in the visual. If you enable this option, the modified cell values are indicated by a pencil icon next to the corresponding values.

Edit cell indicator

3.3. Show row indicator

You can identify manually inserted rows by enabling this option. A pencil icon is displayed next to data input or calculated rows.

3.4. Row label editor

This option allows you to identify if the original row labels are modified in the visual. If you enable this option, the modified row labels are indicated by an edit icon next to the corresponding label.

Row label editor

3.5. Common measure width

Changing the width of one column will change the width of all other columns accordingly when this option is enabled. If this option is disabled, the width of every single column can be changed individually. In the below image, the width of the Qtr 2 column alone is modified.

Common measure width

3.6. Column spacing

This option allows you to adjust the spacing between the columns. If this option is turned on, you can specify the required column spacing in the input field.

The minimum and maximum values of column spacing are 0 and 20 respectively.

3.7. Pin icon

You can select a custom icon for pinned rows and columns.

Pin icon

4. Reading view tooltip

Inforiver offers customizations for the tooltip in the reading view.

4.1. Scaled tooltip for numbers - Enabling this option will display the values in a scaled format in the tooltip.

4.2. Custom decimals - Enabling this option lets you customize the decimal points to be displayed in the tooltip

4.3. Decimal places - Field where you can enter the number of decimal places

The below image shows the values in a scaled format with one decimal point as specified.

Reading view tooltip