Inforiver Reporting Matrix Nov 2024: Variables
Last updated
Last updated
Release notes for version v3.3
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.
Select the Include All Skipped Rows option from the row gripper to include skipped rows again.
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.
Once defined, you can smoothly switch between different time ranges and analyze your data for specific periods.
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.
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.
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.
You can now create a box highlighting specific rows/columns or cells in your reports.
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.
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.
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.
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.
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.
You can quickly switch between different relevant measure combinations with this option.
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.
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.
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.
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.
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.
Absolute search: Locate a value irrespective of its sign. This option has been added to the Misc tab.
Populate missing AC with FC: When the AC measure is unavailable, the missing values can be substituted with the corresponding FC measure.
Customize for Indian numbering system: This enables the lakhs and crores units that are specific to the Indian number system.
Show Info logo: The Inforiver logo will be displayed at the bottom right corner of the visual.
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.
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.
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.
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.
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.
Enable the Suppress Null Visual Columns option to hide visual measures/columns that are entirely blank
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.
We have introduced a new SETCOLUMNSORT scripting function to sort columns in ascending or descending order.
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.
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.
Populate missing FC with PY:
Populate missing FC values 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.
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.
Use the GETLOCALELABEL function in the Title field and pass the Key specified in the translation config.
Notice how the row categories and column groups are implicitly changed to French and German.
3.13. Hide repeating parent rows
Hierarchical datasets may contain categories with the same name on multiple levels.
You can now suppress parent levels with the same name by enabling the Hide Repeating Parent Rows option.