# Inforiver Reporting Matrix Nov 2024 - v3.3 - Variables ## Release notes for version v3.3 [**1. Formatting** ](#id-1.-formatting) 1.1. [Display skipped rows in the report ](#id-1.1.-display-skipped-rows-in-the-report) 1.2. [Date-based interface to show measures ](#id-1.2.-date-based-interface-to-show-measures) 1.3. [Pie and donut – a new addition to row-level charts](#id-1.3.-pie-and-donut-a-new-addition-to-row-level-charts) 1.4. [Minimum and maximum threshold for outliers](#id-1.4.-minimum-and-maximum-threshold-for-outliers) 1.5. [Display marker values for sparklines](#id-1.5.-display-marker-values-for-sparklines) 1.6. [Border box option](#id-1.6.-border-box-option) [**2. Analysis** ](#analysis) 2.1. [Row groups in KPI explorer](#id-2.1.-row-groups-in-kpi-explorer) 2.2. [Date picker in filters](#id-2.2.-date-picker-in-filters) 2.3. [Filter based on measure name](#id-2.3.-filter-based-on-measure-name) 2.4. [Interface change for filters ](#id-2.4.-interface-change-for-filters) 2.5. [Date range conditions in conditional formatting](#id-2.5.-date-conditions-in-conditional-formatting) 2.6. [Hide measure values with conditional formatting](#id-2.6.-hide-measure-values-with-conditional-formatting) 2.7. [Conditional formatting for measure headers](#id-2.7.-conditional-formatting-for-measure-headers) [**3. Settings** ](#settings) 3.1. [Totals/subtotals for date fields](#id-3.1.-totals-subtotals-for-date-fields) 3.2. [APS options moved to display settings](#id-3.2.-aps-options-moved-to-display-settings) 3.3. [Custom suffix for row subtotals split](#id-3.3.-custom-suffix-for-row-subtotals-split) 3.4. [Custom labels for blank row and column categories ](#id-3.4.-custom-labels-for-blank-row-and-column-categories) 3.5. [Show column filter](#id-3.5.-show-column-filter) 3.6. [Rotate the first row dimension vertically](#id-3.6.-rotate-the-first-row-dimension-vertically) 3.7. [Suppress null visual columns](#id-3.7.-suppress-null-visual-columns) 3.8. [On data change scripts](#id-3.8.-on-data-change-scripts) 3.9. [Reset formats for selected cells](#id-3.9.-reset-formats-for-selected-cells) 3.10. [Populate missing FC with PY/PL](#id-3.10.-populate-missing-fc-with-py-pl) 3.11. [Right-to-left support](#id-3.11.-right-to-left-support) 3.12. [Localization settings](#id-3.12.-localization-settings) 3.13. [Hide repeating parent rows](#id-3.13.-hide-repeating-parent-rows) [**4. Annotations** ](#id-4.-annotations) 4.1. [Identify notes added in the MOR layout ](#id-4.1.-identify-notes-added-in-the-mor-layout) [**5. Manage columns**](#manage-columns) 5.1. [Absolute moving average ](#id-5.1.-absolute-moving-average) 5.2. [Flexible position for simulation percentage](#id-5.2.-flexible-position-for-simulation-percentage) 5.3. [Empty measures and columns ](#id-5.3.-empty-measures-and-columns) [**6. Manage rows** ](#manage-rows) 6.1. [Template rows retained after base rows removed](#id-6.1.-template-rows-retained-after-base-rows-removed) 6.2. [Time intelligence formulae ](#id-6.2.-time-intelligence-formulae) 6.3. [Access the measure name in the formula ](#id-6.3.-access-the-measure-name-in-the-formula) 6.4. [Select rows based on date range](#id-6.4.-select-rows-based-on-date-range) [**7. Variables** ](#variables) [**8. Groups for field parameters** ](#field-parameters) [**9. Aggregation - new column aggregation types – first and last** ](#aggregation) [**10. Filter context - context awareness for notes columns** ](#filter-context) 10.1. [Context awareness for notes columns ](#id-10.1-context-awareness-for-notes-columns) [**11. Design** ](#design) 11.1. [Hyperlinks in the header/footer ](#id-11.1.-hyperlinks-in-the-header-footer) 11.2. [Headers will be retained in the Report+ layout](#id-11.2.-headers-will-be-retained-in-the-report-layout) 11.3. [Row category displayed for KPI ](#id-11.3.-row-category-displayed-for-kpi) 11.4. [Show dimension category with markers](#id-11.4.-show-dimension-category-with-markers) [**12. Conditional formatting for exports** ](#conditional-formatting-exports) 12.1. [Conditional formatting for exports ](#id-12.1.-conditional-formatting-for-exports) 12.2. [Decimal precision for exports](#id-12.2.-decimal-precision-for-exports) [**13. Performance mode enhancements** ](#performance-mode) [**14. Re-ordering rows** ](#re-ordering) [**15. Image URLs in measure headers**](#image-urls) [**16. Row gripper enhancements** ](#row-gripper) 16.1. [Select descendants ](#id-16.1.-select-descendants) 16.2. [Edit/Delete measures in MOR layout ](#id-16.2.-edit-delete-measures-in-mor-layout) 16.3. [Select column option ](#id-16.3.-select-column-option) 16.4. [Multi-select row option in gripper](#id-16.4.-multi-select-option-in-row-dimension-header-gripper) [**17. Reading view enhancements** ](#reading-view) [**18. Convert native measures to visual columns**](#view-enhancements) [**19. Other New Functions**](#other-enhancements) [**20. Other Enhancements**](#id-20.-other-enhancements) ## 1. Formatting #### 1.1. Display skipped rows in the report Inforiver allows you to exclude rows from total/subtotal calculations using the Skip row option. The skipped row will then be masked from the report. With the latest release, you can retain skipped rows in the report with the Skip and Show Row option in the row gripper. This feature allows you to cherry-pick the categories contributing to the subtotals and display the excluded categories. Notice how the Bookcases row is still displayed in the report after skipping it. The subtotals for the Furniture and Central categories and the grand total have changed after excluding the Bookcases row.

Skip and show row

Select the **Include All Skipped Rows** option from the row gripper to include skipped rows again. #### **1.2. Date-based interface to show measures** Inforiver offers a range of time intelligence formulas to display your data for specific periods. If scripting is not your cup of tea, you can use the new **Show Measures** interface to display the data for a particular period of time. You only need to select the date range from the date picker. You can also hide measures for a specific time range by turning off the **Show** toggle.

Show measures setup

Once defined, you can smoothly switch between different time ranges and analyze your data for specific periods.

Defining multiple time periods and switching between them

#### **1.3. Pie and donut – a new addition to row-level charts** Add a pie or donut chart to your report to visualize the proportions of different categories in your dataset. To embed pie charts, add a minimum of 2 measures.

Embedding pie and donut charts

#### **1.4. Minimum and maximum threshold for outliers** Inforiver can highlight outlier values for lollipop charts, and you can specify the threshold beyond which a data point will be considered an outlier. In earlier versions, we only had the option to specify a negative and positive outlier, but what if you only have positive values in your data? In the latest version, you can specify a minimum and maximum threshold or use the existing positive/negative option based on your data.

Outlier threshold

#### **1.5. Display marker values for sparklines** Inforiver enables you to visualize your numbers by embedding row-level charts. By checking the **Show Marker Label** option, you can now display markers alongside the charts, allowing you to grasp insights quickly from the charts.

Sparkline markers

#### **1.6. Border box option** You can now create a box highlighting specific rows/columns or cells in your reports.

Border box

If you have applied Power BI filters on row/column dimensions, the border box will automatically expand to accommodate the filtered categories when they are added back. Please remember that this will work only when you use the row/column gripper options to select data when you apply a border.

Power BI filter compatibility

## 2. Analysis #### **2.1. Row groups in KPI explorer** With Inforiver, you can group rows and create visual-level hierarchies. In earlier releases, row groups could not be viewed or selected from the KPI explorer. From this release, row groups will be supported in the explorer view.

Row groups in KPI explorer

#### **2.2. Date picker in filters** Inforiver makes it easier for you to apply filters for date fields. You can select the date ranges from the date picker, which is now available in the filter interface. Note: You need to have a date dimension in your report to enable the date picker.

Date picker in filters

When you have a date dimension in your rows, you can use the new **Date Period** option to filter your row data between 2 specific dates.

Date period filter

#### **2.3. Filter based on measure name** Navigating and locating specific measures may prove time-consuming when your reports contain many measures. You can now display selected measures by creating measure-name-based filters.

Measure filter

You can quickly switch between different relevant measure combinations with this option.

Measure filters

#### **2.4. Interface change for filters** Is deciphering complex, multi-condition filters proving to be laborious? The filter interface has been upgraded to show the links between filter conditions, making them much easier to grasp.

New filter interface

#### **2.5. Date conditions in conditional formatting** You can directly use date range conditions, such as the order date being in the last n days or the ship date being in the next n days, as a conditional formatting rule.

Date-based conditional formatting

#### **2.6. Hide measure values with conditional formatting** Business reporting may require withholding certain information to protect strategic interests. You can now use conditional formatting to mask values based on specific criteria. We’ve hidden the COGS values when the Discount is less than 10k.

Hiding measure values

#### **2.7. Conditional formatting for measure headers** Based on your data, you can highlight measure headers. For instance, you can highlight the quarters/months in which the overall sales exceed a target amount. You can select the dimensions from the **Target column** box.

CF for measure headers

## 3. Settings #### **3.1. Totals/subtotals for date fields** Aggregation may not necessarily apply to non-numeric fields. Inforiver provides the option of leaving the total and subtotal cells blank for non-numeric fields. This feature has been extended to date fields as well in this release.

Disable totals/subtotals for non-numeric measures

#### **3.2. APS options moved to display settings** * **Absolute search:** Locate a value irrespective of its sign. This option has been added to the Misc tab.

Absolute search

* **Populate missing AC with FC:** When the AC measure is unavailable, the missing values can be substituted with the corresponding FC measure.

Replace missing AC with FC

* **Customize for Indian numbering system:** This enables the lakhs and crores units that are specific to the Indian number system.

Indian number system

* **Show Info logo:** The Inforiver logo will be displayed at the bottom right corner of the visual.

Show info logo

#### **3.3. Custom suffix for row subtotals split** Inforiver allows you to customize the row and column totals and subtotals with the Totals feature. The subtotal is displayed as a separate row when you choose the split option for row subtotals. After splitting subtotals, you can set a custom suffix for the row subtotal.

Subtotal suffix

#### **3.4. Custom labels for blank row and column categories** Inforiver provides numerous options for handling null data in the source. With the latest version, you can provide a default label for blank row and column dimension categories.

Custom labels for blank dimensions

#### **3.5. Show column filter** We’ve added a new, easily accessible column filter interface. This can be enabled by turning on the **Show Column Filter** option in the Misc tab. The **Enable Canvas Rendering** option should also be enabled from the General tab.

Show column filter

#### **3.6. Rotate the first row dimension vertically** You can display the dimension in the Rows parameter in a banner format with the categories rotated vertically. To turn on this option, the General settings > Enable Canvas Rendering option also needs to be enabled.

Rotate row dimension

#### **3.7. Suppress null visual columns** You may have calculated fields in your report that are null for certain categories. Inforiver provides the option of suppressing such fields that do not add value to the report.

Suppress null visual columns

Enable the **Suppress Null Visual Columns** option to hide visual measures/columns that are entirely blank

Suppress null visual columns

#### **3.8. On data change scripts** You can now execute scripts on changing the data selections in an external slicer/filter. For instance, you can enhance the relevance of data by drilling up/down or mask data in response to a specific selection. The exact scripting functions used in variables or on-load can be used for data changes.

On data change scripts

* We have introduced a new SETCOLUMNSORT scripting function to sort columns in ascending or descending order.

SETCOLUMNSORT function

#### **3.9. Reset formats for selected cells** Have you ever applied a series of formatting changes and found it challenging to undo them? Inforiver provides a handy **Reset Formats** option. Select the cells and click **Reset Formats** to instantly restore default formatting.

Reset formats for selected cells

#### **3.10. Populate missing FC with PY/PL** If your reports contain forecast measures with missing values for certain periods, you can use either PL or PY values to replace the null forecast values.

Missing FC values

Populate missing FC with PY:

Populate missing FC with PY

Populate missing FC values with PL:

Populate missing FC with PL

#### **3.11. Right-to-left support** 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. * The header is positioned at the right end of the report.

RTL support

#### **3.12. Localization settings** You can configure translations in Inforiver based on the language settings in Power BI. If your report has a global audience, you can configure calculated rows/columns or column groups to display dimension categories based on pre-defined translations when the language is switched. Navigate to Display Settings > General > Localization Settings to create translation entries.

Localization settings

Use the GETLOCALELABEL function in the Title field and pass the Key specified in the translation config.

GETLOCALELABEL

Notice how the row categories and column groups are implicitly changed to French and German.

French

German

#### **3.13. Hide repeating parent rows** Hierarchical datasets may contain categories with the same name on multiple levels.

Repeating categories

You can now suppress parent levels with the same name by enabling the **Hide Repeating Parent Rows** option.

Hide repeating parent rows

## 4. Annotations #### **4.1. Identify notes added in the MOR layout** While analysing your report, you may need to switch between the regular layout and the measure-on-rows layout. The notes added in the measure-on-rows layout will have an MOR tag. This will enable users to identify and differentiate between the notes added in different layouts. The notes added in the MOR layout can only be viewed and not edited in the default layout. The reverse happens when we add notes in the normal layout and switch to the measure-on-rows layout.

Notes added in MOR non-editable in default layout

## 5. Manage Columns #### **5.1. Absolute moving average** We have expanded the moving average functionality to include an absolute moving average option. In the sample report, we calculate the moving average over two days. When you choose the ‘Absolute’ average type, if the previous day’s data is unavailable, the current day value will be considered for the average. For example, the data for Jan 5th is not available, so the moving average for Jan 6th considers only that day’s quantity of 13, and the moving average is calculated as 6.50. On the other hand, on Jan 12th, data for Jan 11th is also available. The moving average of 17.50 accounts for both the quantities of 8 and 27.

Absolute Moving Average

The current period value is used when the average type is set to ‘Rolling’ and the previous period is unavailable. Notice how the moving average on Jan 6th is the same value as the quantity.

Rolling Average

#### **5.2. Flexible position for simulation percentage** Inforiver supports what-if analysis with the simulation feature. A **Simulation Value** option has been added, allowing you to display the simulation percentage to the right or left of the simulated value. You can also display only the percentage and suppress the value itself. You must first add simulations to a measure to display the simulation percentage alone.

Flexible position for simulation percentage

#### **5.3. Empty measures and columns** Do your reports appear overloaded with information? De-congest your reports by inserting empty measures or columns. You can re-order the empty measure/column by dragging it to the required position. Please remember that the empty measures and columns feature is intended for aesthetics only. They can be used primarily to demarcate your data.

Empty measures and columns

## 6. Manage rows #### **6.1. Template rows retained after base rows removed** Inforiver allows you to insert calculated rows at each level of the hierarchy. In earlier versions, the template row was lost if the base row was removed from the report. From this release, template rows will be retained regardless of whether the base row is present. In the sample report, notice how the template row *Furniture tax* is preserved in the report, although the base row, *Furniture*, has been removed.

Template rows retained after base rows removed

#### **6.2. Time intelligence formulae** The release allows you to access the following/previous time periods using the new COLUMN\_PERIOD.NEXT/LAST time intelligence formulae. Please remember that a date dimension should be added as a column parameter to use this function.

Time intelligence formula

When you click on a cell, Inforiver highlights the cells contributing to that value. Notice how the Actuals from the previous quarter have been highlighted.
#### **6.3. Access the measure name in the formula** You may need to assign values based on the measure name. Instead of manually keying in the values for each cell, you can now use the ROW\.MEASURENAME identifier to access the respective measure names in a formula.

Access the measure name in the formula

#### **6.4. Select rows based on date range** In business reporting, you may need to apply formulas to a specific range of data. For instance, you could calculate the average for a week or a fortnight. When you have a time dimension in your rows, you can use the SELECTROWS formula to fetch the rows for a particular time period.

Select rows based on date range

## 7. Variables Inforiver variables facilitate user-driven data navigation and filtering. We will be adding controls in the upcoming releases, which, powered by variables, will serve as an indispensable tool for drawing instant interpretations from your data. * **Variable types** Inforiver supports text, numeric, date, date range, and boolean data types. The advanced data type allows you to provide a formula or calculation within the variable. Click on the pencil icon to customize the variables, i.e., to set default values, assign option values, or rename the variable.

Variable types

* **Inserting variables into the visual** You can insert variables into your reports from the Header & Footer tab. Navigate to Type > Variables. All the variables created in the visual will be inserted in the header. Note: To hide a variable, enable the **Hide on visual** toggle in the edit variable side pane.

Inserting variables

* **Using variables to filter data** Let’s look at how to use a *Select* variable to dynamically filter dimension categories. We’ve created a variable that contains the category values as options.

Using variables to filter data

We need to create an Inforiver filter using the *Select* variable as input. Notice how the *Select* variable can be accessed from the filter IntelliSense.

Select variable

You can then filter and navigate your data using the dropdown control in the header. Instead of using a *Select* variable, you can also use a *Text* variable. The user can key in their selection, and Inforiver will use the text entered to filter data.

Text filter

* **Using variables in formulas** You can reference variables within formulas. Inforiver’s IntelliSense will display *the technical name* of the variable when you key in the first letter(s).

Using variables in formulas

Notice how the formula measure, EnhcSales, changes when we enable and disable the ‘Active’ toggle control.

Variable as toggle

You can also use a *Number* variable to pass user input values to a formula measure. For example, you can pass the interest rate and determine its impact on your profits. * **Filtering dates** Inforiver provides *Single date* and *Date range* variables that you can use to select data for a specific date or period. When you have a date dimension in your rows, you can choose the **Single Date** option in your Inforiver filter. IntelliSense will display the *Single date* variables in your visual, which you can pass to the filter. Similarly, when you choose the **Date Range** option as your comparison method, IntelliSense will display the *Date Range* variables you created.

Date variable

We can select a date range from the header control to filter rows for a specific period.

Select date range from header control

* **Variable groups** With Inforiver, you can save variable configurations to filter or select data by creating groups.

Variable groups

You can then easily switch between configurations. Notice how the date range, number variable, and options have different values when we switch between groups.
variable-groups-switch

Switch variable groups

* **New scripting functions** We’ve introduced additional scripting functions for variables, on-load, or data change scripts.

New Variable-based Scripting functions

Scripting function used

All the formatting, font, and row/column total position changes are applied when we run the script.

Output after running the script

* **Enable toggle scripts** When you work with variables, you can specify one set of scripts for the active state of the variable and another for the inactive state. In this example, when the button is enabled, the label reads “ENHC READABILITY,” and the corresponding scripts are executed. Similarly, the button is disabled, the **Disabled script** section is executed.

Toggle button script

Notice how different scripts are executed each time we click the button.
toggle-scripts-execution

Toggle script execution

* **Floating toolbar for buttons in reading mode** The Allowed User Controls setting allows you to display a floating toolbar in reading mode. Report users can enable button variables in the floating toolbar and access them. You can also provide access to features like conditional formatting or export with the floating toolbar and restrict access to the regular toolbar. Report users can only use variable buttons to run scripts.

Display floating toolbar

Floating toolbar in reading view:

Floating toolbar in reading view

* **Global functions** Inforiver allows you to reuse scripts/formulae by defining them inside a global function. Instead of repeating the logic in multiple places, you can call the global function inside a variable/on-load script or on-data change script. Navigate to Display settings > Scripting > Insert New to create a global formula.

Global functions

You can use the global function name in the script section to create a variable or set up on-load/on-data change scripts.

Execute the global function

* **Editing variables** After creating variables, if the variable panel is enabled, you will see an edit icon when you hover over the variable. You can always click the Variables button in the toolbar and edit from the Variables side pane.

Editing variables

## 8. Groups for field parameters Field parameters are often used in Power BI to create dynamic reports where users can interactively change the dimensions or measures displayed in visuals. In the latest version, you can create custom groups with field parameters. Creating custom groups was supported in earlier versions as well with the **Add New Group** option.

Add New Group

Custom groups are created under the column dimension category from where the measures are selected and not replicated across all categories. Notice how the group is created under Qtr1 only.

Custom group

When you work with field parameters, you can create parameter groups using the **Group Parameters** option. Parameter groups are replicated across all column dimension categories. To start with, we’ll create a field parameter group that includes all the measures in the field parameter.

Create Parameter Group

Even when you change the measure selection, the measures from the field parameter are still grouped together.
field-parameter-groups-measure-changes

Grouping is retained even when measures are changed

You can even create sub-groups. In this example, we’ve renamed the default group to: * **Actuals** when the actuals measures are selected * **Plan** when the plan measures are selected * **2024** when 2024 Actuals + 2024 Plan are selected Notice how the group name changes dynamically when we select measures corresponding to the groups. For other measure selections, the default group name is used.
measure-grouping-field parameters
## 9. Aggregation #### **9.1. New column aggregation types – first and last** P\&L or cash flow statements often require the values from the first or last periods as the column subtotals and grand totals. * First aggregation type: The values from the first period are used for the column subtotals and grand totals. In the example, the Actuals from Q1 are used as the subtotals at the year level. The Actuals from 2022 (the earliest year) are used for the grand total.

Aggregation type- First

* Last aggregation type: The last period is used to populate the grand totals and subtotals.

Aggregation type - Last

## 10. Filter Context #### **10.1 Context awareness for notes columns** The Inforiver visual is receptive to changes in external filters. With the current release, context awareness has been extended to note columns as well. Row-level notes will be updated dynamically based on slicer selections.
filter-context-notes-columns

Filter context for Notes column

## 11. Design #### **11.1. Hyperlinks in the header/footer** Including the brand name in the report header/footer helps reinforce brand recognition among readers. This can be particularly useful in documents shared with stakeholders who may not be familiar with the brand. For additional context, you can now include hyperlinks in the header/footer. Key in the text, select it, and use the link icon from the toolbar to convert the text into a hyperlink to the website.

Hyperlinks in header

#### **11.2. Headers will be retained in the Report+ layout** In earlier versions, the header would be replaced by the Report+ header when working in the Report+ mode. Custom headers will still be visible in the Report+ layout with the current release.

Headers retained in the Report+ layout

#### **11.3. Row category displayed for KPI** You will now see the row category data used to populate the KPI presets in the header. Since Inforiver allows you to manually change the underlying data, this enhancement lets you put the KPI metrics and charts in perspective.
row-category-kpi-header

Row category displayed for KPI

#### **11.4. Show dimension category with markers** Similar to the row category option for KPI, for header charts, when you enable markers, you can choose to show the dimension categories – users will be able to correlate the metrics with the associated categories.

Show dimension category with markers

## 12. **Export** #### **12.1. Conditional formatting for exports** Inforiver reports support a variety of conditional formatting options that enable you to highlight your data and draw quick insights at a glance. You can retain or remove conditional formatting when exporting the report. Navigate to the Export tab > Page Setup > Export with conditional formatting. You can select the conditional formatting rules for the report extract.

Conditional formatting for exports

Notice how the classification text has been removed from the PDF extract.
You may have conditional formatting rules that have been disabled, but you can still include them in the export. For example, the CF rule to highlight negative values in the variance column has been disabled in the report but enabled in export settings.

conditional formatting - only for exports

The Excel export contains the conditional formatting on the variance column, which was turned off in the report.
#### **12.2. Decimal precision for exports** You can set a specific decimal precision for exports in the latest version. You can also set different precisions for the report and the export. Navigate to Export > Page Setup and select the precision from the dropdown. When you choose ‘Auto,’ the report and export will have the same precision.

Decimal precision for exports

In this example, although the report has a precision of 2 decimal places, the PDF extract has six decimal places.

export result

## 13. Performance mode enhancements The Inforiver architecture provides extensive support for hierarchical data. In performance mode, you can drill down and roll up operations on large datasets of more than 100k cells. In the latest version, you can use performance mode even with **two dimensions**; in earlier versions, you could switch to performance mode with only a minimum of 3 dimensions. You can now use the filter and data input (except numeric) capabilities previously restricted in performance mode. Note: the current version does not support named filters. * **Data input in performance mode:**

Data input in performance mode

* **Filters in performance mode**:

Filters in performance mode

## 14. Re-ordering rows You may need to manually change the order of rows at the visual level. When you have a hierarchy with child categories that repeat across all the levels, you would want a row rearrangement to be reflected across every level. In earlier versions, you would have to painstakingly reorder the rows for each level. In the latest version, you just need to change the order in one level which will be reflected across the entire hierarchy.
re-ordering-rows-hierarchy

Re-ordering rows in all levels

## 15. Image URLs in measure headers In earlier versions, we introduced support for image URLs, allowing you to embed images in your rows, categories, or cells. Images make reports more interactive and help add visual context to your data. In this release, you can also use image URLs as measure headers. To use the image throughout the measure header, navigate to the Display settings > Misc > View section and enable the **Fill Image** toggle.

Image URLs in headers

## 16. Row gripper enhancements #### **16.1. Select descendants** In the latest version, you will notice multiple options for selecting descendants from the row gripper. You can choose the dimension, parent + children, only the categories, children only, etc. With the Select Descendants option, you can uniformly format all the child rows under a parent node in one stroke. Instead of manually selecting each row and applying formatting, you can select all the child rows in one click.
row-gripper-select-descendants

Select descendants

#### **16.2. Edit/Delete measures in MOR layout** We have improved accessibility in the measure-on-rows layout. You can now directly edit and delete visual measures from the row gripper.

Edit/delete measure in MOR layout

#### **16.3. Select column option** You can right-click a column dimension category and choose the **Select Column** option to select all the measures under that category. You can then apply formatting or apply a border to the selected columns.

Select Column option

#### **16.4. Multi-select option in row dimension header gripper** Inforiver allows you to enable checkboxes against each row category to easily select rows. We have made this option more accessible by adding it to the row dimension header gripper.

Multi-select rows option in gripper

## 17. Reading view enhancements You can adjust the font size in the reading view, making the content more accessible to a broader audience.

Reading view enhancements

## 18. Convert native measures to visual columns When you assign measures or dimensions to the AC/PY/PL/FC/Others parameters, the native measures and dimensions are displayed for each column dimension category. You now have the option to display them as visual columns. Navigate to **Manage Columns > Settings**. Enable the toggle buttons against native fields to display them like visual columns.

Convert native measures to visual columns

Notice how the quantity, profit, and segment are displayed at the end of the report in a similar way to the visual columns.

As visual columns

## 19. Other New Functions \- **GETMEASUREBYINDEX**: The GETMEASUREBYINDEX() formula will fetch measure values based on the index. For example, the first measure can be referenced using its index of 0, the second will have an index of 1, etc. \- **GETCOLUMNBYINDEX**: Similar to GETMEASUREBYINDEX, you can use GETCOLUMNBYINDEX() to fetch column values based on the index. \- **SHOWMEASUREBETWEENPERIOD**: The SHOWMEASUREBETWEENPERIOD script now accepts multiple measures. You can use a single script to display various measures between a specific period instead of repeating the script for each measure. E.g., SHOWMEASUREBETWEENPERIOD(LASTNMONTH(5),\[\[2024 Actuals], \[2023 Actuals], \[2022 Actuals]]) ## 20. Other Enhancements \- **Expand formula for edit cells**: When you edit cells, Inforiver enables you to enter long, complex formulae by providing an option to expand the formula bar. Click the new expand icon at the right end of the formula bar to maximize it. \- **Expand/Collapse for Hierarchical Column Dimensions:** You can always display the expand/collapse icon for hierarchical column dimensions. In earlier versions, the icon appeared only on hover, and users may not be aware that the column dimension is hierarchical. Navigate to Display Settings > Hierarchy > Column Totals > Expand/Collapse—select ‘Always Present’ from the dropdown. \- **Total cell count in statistics**: You can now see the total number of cells in your report when you click the Inforiver logo and open the Statistics tab. \- **License validity:** The license validity will now be displayed in the License tab when you click on the Inforiver logo. \- **Edit measure headers for PY/PL/FC/Others:** You will be able to double-click and edit measure headers even when measures/dimensions are added to the PY/PL/FC/Others fields, which was not allowed in earlier versions. \- **Hide hierarchy options**: The ‘Hide Icon & Children’ and ‘Hide Icon for Level’ options will be available in the row gripper even when the hierarchy level is collapsed. \- **Double border:** You can apply a double border to native measures/forecasts/locked cells/data inputs from the Column Style > Customize window. Please bear in mind that the row height needs to be more than 26 for the double border style option to be enabled. That brings us to the end of the Inforiver Reporting Matrix v3.3 release updates. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/release-notes/inforiver-reporting-matrix/inforiver-reporting-matrix-nov-2024-v3.3-variables.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.