Last updated
Was this helpful?
We’ve expanded Infobridge data integration capabilities – you can now import Fabric Lakehouse tables and cascade them into your connected planning reports in Inforiver!
Enter the workspace, Lakehouse, and table name to integrate the Lakehouse source. Please bear in mind that Fabric Lakehouse and Azure Data Lake Storage need to be in “Connected” state in the Admin console > My Integrations section.
Inforiver’s signature Writeback can now connect to Fabric SQL destinations. You can consolidate Inforiver reports and connected planning reports from Infobridge into Fabric SQL destinations.
Inforiver reports often contain visual columns like tax rates or multiplier factors. Infobridge supports visual columns as well – you can integrate visual columns into your connected planning reports.
Note: the visual column will be treated as a visual measure within Infobridge, with the same values repeated for each column dimension category.
Connected planning reports often have varying granularities. For example, you may have a regional budget that is cascaded into a global budget target report. The target report is likely to have slicers on dimensions like quarters, product lines, tax segments, etc.
Inforiver’s built-in context awareness has been extended to Infobridge sources - enabling context-aware connected planning. Let’s look at a quick demonstration. Our bridge contains quarterly Discounts that we need to integrate into our yearly profitability report.
The target Yearly Profitability report contains data at year-level. Before integrating the discounts from Infobridge, let’s use Inforiver’s Super Filter visual to set up context awareness in the target.
The target visual has data at a higher granularity, i.e. year-level and the source bridge has quarterly data. When we create an integration to the discount bridge, we need to map the Quarter dimension to the filter context measure in the target profitability visual.
Note: When you need to import a measure/column from Infobridge, the filter context measure needs to be mapped to the column dimension. When you import rows and have a slicer for row dimensions, the filter context measure should be mapped to the row dimension.
Notice how the Infobridge measure, Discount, also changes in response to slicer selections.
The Inforiver suite is being constantly upgraded to provide a seamless user experience. In the latest version, you'll notice that when an initial data preparation job fails in Infobridge, it will automatically be re-triggered once.
You'll notice that the measure and scenario selection window has a more user-friendly interface.
- Row gripper and Toolbar options
The Insert custom row options from the row gripper are now more accessible and better organized. Some of the options have also been renamed to make them more user-oriented – ‘Static rows’ to ‘Data Input’ and ‘Calculated rows’ to ‘Formula’.
Similar to the Row gripper options, the Insert Row options from the toolbar have also been reorganized to streamline your experience.
- Changing the row type
You have the flexibility to switch between data input, calculated, and aggregated rows at any time with the new Row Type dropdown. For instance, you may have used a formula and referred to the values of an existing row dimension while creating the row. You can easily change it to data input and enter values without having to create a new data input row.
- Convert to template rows
You can also convert a custom row to a template row – i.e. the row will be available across all levels of the hierarchy. For instance, you may create a product line specific to a particular region. You can use the Templated option to replicate the same product line across all regions.
- Row management interface
The Manage Rows interface has been redesigned to enable you to efficiently govern custom rows in your Inforiver reports. Each type of row: calculated, aggregated, data input, and template can be identified based on the row icons. Use the Tree View to easily identify the hierarchy level where a specific row was created.
The List view displays rows in the order that they were inserted.
- Add child rows and sibling rows
You can instantly add child rows and sibling(at the same level of the hierarchy) rows right from the Manage Rows side pane.
- Search and filter custom rows
Use the Search and Filter options to search for a particular row category or display rows based on the type.
With Inforiver, you can add organizational hierarchies or product lines on the fly with the Insert Rows feature. In the latest version, you have the flexibility to apply custom calculations on parent rows. In earlier versions, we would need to manually enter values for data input rows.
Select Formula from the Row Type dropdown. You can enter custom calculations and refer to row dimensions categories.
If you have hierarchical row dimensions and want to disable row insertion for a specific dimension, this will automatically disable row insertion for all levels above it.
Measure backup jobs have dedicated logs that show the status of the backup, milestones, and the backups that are deleted when the limit is reached. Click the View jobs option from the Schedule Measure Backup side pane.
Variables accept user input and enable report users to navigate hierarchies, apply filters, run scripts, perform dynamic calculations, and rank data on the fly. The new easy-to-navigate UI ensures a smooth experience for creating and maintaining your variables.
See how variables can make report navigation and editing easier without creating Inforiver filters or manually editing the header or visual measures.
If your subscription job is running long or you need to make additional modifications to your report before sending it out, you can use the new Cancel Job option in the scheduler. This will immediately abort the subscription and cancel both the parent and child jobs without having to abort each child job individually.
You’ll notice that the status of all your jobs is changed to Failed.
You can now persist the status of your child job runs and save it to your desktop. Click the Export Jobs button to create an Excel extract.
We’ve upgraded the Inforiver Sorting algorithm to provide advanced nested sorting options. You can sort your data based on multiple dimensions or measures. Please bear in mind that you can either sort based on row dimensions or based on measures, not both together.
With Inforiver’s Comments feature, you can allow users to collaborate and add more context to your reports. It doesn’t stop at that – you can set priorities for comments, post replies, schedule comment digests, and assign permissions. In this version, the Comment settings have been re-structured to enhance accessibility.
You can create starred comments, filter based on resolved/starred/your threads, and sort comments on priority/creation time from the View All Comments side pane.
When you create notes in Inforiver, you can enable marker mode to highlight important observations while presenting your report. You can now set the color, shape, and width of markers.
Inforiver’s differentiated architecture enables faster processing of large hierarchies, ensuring optimal performance while creating reports with complex hierarchical data. To efficiently analyze extensive hierarchical datasets without compromising on performance, we recommend switching to the new Performance Table layout.
Note: This layout can be applied only when the report does not contain any column dimensions.
Inforiver’s audit log feature now captures a much higher level of information:
- User details along with timestamp when the report is modified.
- Changes to settings like default values will be recorded in the audit trail for custom columns and rows,
- Measure resets will be recorded.
Normal distribution is widely used in financial reports and analysis for performance benchmarking, portfolio risk management, interest rate modeling, and other purposes. The latest version of Inforiver allows you to use normal and inverse distribution formulae.
Supported formulae:
Visualize your numbers better with inline charts in your matrix reports. You can now apply conditional formatting for inline charts, enabling stakeholders to identify trends and outliers easily.
You can highlight row headers with conditional formatting when your actuals satisfy pre-defined conditions. Select Row Headers from the Apply to dropdown. You can use conditional formatting to set a border, font style, font color, and cell background for row headers.
You can use icons and text to highlight date measures with conditional formatting.
Enhance the visual appeal of your reports with icons and symbols in measures headers, column headers, and inserted rows. You can copy the preferred icon and paste it in the title section.
Highlight your data input fields like number, dropdown, and person columns with conditional formatting. When users enter values, you can specify rules to automatically apply formatting when the rules are satisfied e.g. spotlight the cells when the budget entered exceeds a certain limit.
In the Customize tab, you have options to apply common scaling for all measures or individual scaling for each measure.
You can set custom padding between the stacks in a stacked bar chart.
You can highlight non-numeric measures using the is blank/is not blank conditions. We've set a hatched background for the cells with blank customer names.
If you've opted for classification formatting, you can choose to enable a background for the text. This option is only available for text classification, not icons or ratings.
You can use the handy date picker when you need to filter writeback logs between specific create time ranges.
When you sort measures from the column gripper, you'll notice that the sort icons have been upgraded to a more intuitive version.
With Inforiver, you can select the data displayed in header charts and KPIs. In the latest version, you can refer to visual measures, formulae, forecasts, simulations, and data inputs in header charts and KPIs.
You can now use custom date formats when you have non-hierarchical date fields in your dataset.
When you convert a measure to a percentage or vice-versa, Inforiver will provide a link in the notification that will allow you to easily switch to native aggregation if needed.
You can use the row gripper to flatten custom row hierarchies. Notice how the parent Operations group is removed and the child categories are converted into parent categories after ungrouping.
The Remove Group option will delete the parent category i.e. remove the selected level of the hierarchy including all child records.
Significant performance optimizations will enable you to seamlessly distribute and allocate forecasts/data inputs for up to 1 million cells.
Report users will be able to lock and unlock cells in read view. They will not however be able to unlock cells that were locked by the report author.
Report authors can choose to give users access to certain display settings like ragged hierarchy, semantic formatting, and null/zero handling with scripts. When used with variables, users will be able to turn these settings on or off although they cannot directly access display settings.
We've added a search bar to enable you to quickly locate dimensions while creating scenarios or fetching options from a semantic model.
You can override the global semantic model format set in Display settings and apply individual semantic formatting for measures from the column gripper. The Show (-ve) Sign option has been replaced with the measure-level semantic formatting option in the column gripper.
The Sign in Headers option could be applied only to IBCS templates in earlier versions. You can now use it for all Inforiver templates.
Crop issues in the Customize tab while using the Minimal with tabs toolbar have been fixed.
12.14. IN clause for data input text filters
You will now be able to filter data input text fields with an 'IN' clause - allowing you to easily narrow down your data.
12.15. Additional options for Inforiver filters
You can now leverage options like contains/does not contain, begins with/ does bit begin with, ends with/ does not end with, is empty/is not empty.
12.15. RGB color format in color picker
When you set a custom color, you can specify RGB and RGBA formats in the color picker.
12.16. Empty rows resize
You will now be able to resize empty rows up to 4px.
12.17. Grand totals to be rendered for bar, pin, and waterfall
Inforiver can render bar, pin, and waterfall charts in the column grand total. Enable the Charts on column grand total option from Display Settings to plot charts.
12.18. MoR column width
You will be able to manually enter the column width in the MoR layout. Navigate to Manage Rows > Settings > Manage Columns and enter the value in the Width field.
12.19. Measure header label in MoR layout
When you don't have row dimensions assigned in the MoR layout, you can set a custom measure header. Navigate to Display Settings > Measure Header Label and input the label of your choice.
12.20. Custom row total/subtotal label in outline layout
You can set custom labels for the row totals and subtotals in the outline layout as well. The row dimension category can be used as the prefix/suffix and you can input a title of your choice in the textbox.
12.21. Filter context - locked cells
When you lock cells after making a slicer selection, the locks will be retained even after changing the selection.
12.22. Filter while fetching data
When you apply Inforiver filters on large datasets, there is a remote chance that users may glimpse unfiltered data as it is being loaded into Inforiver. If your data is confidential, you can enable the Filter while fetching data option in Display Settings to ensure that data is not exposed.
12.23. Column filters for date measures
You can now apply column filters to narrow down date measures easily.
12.24. Expand column to last level
When you have a column hierarchy in your reports, enable the Expand column to Last Level toggle in Display Settings to automatically expand the hierarchy when the report is loaded.
12.25. Frozen measure header and row categories for exports
Measure headers and row categories will be frozen by default for Excel exports.
12.26. Extended time limits for open forecasts
You can generate forecasts for longer time periods:
YEAR
25 years
HALF YEAR
20 years
QUARTER
15 years
MONTH
10 years
WEEK
5 years
DAY
2 years
12.30. Suppress NULL options in MoR
You now have separate options to suppress native measures and Inforiver measures that are null.
When the number of rows being written back exceeds a threshold, you'll need to enable a temporary staging table in the destination config. Writeback will fail unless the staging table option is enabled.
An email notification will be generated when a scheduled writeback fails.
You can delete a particular note in the Notes column by hovering over it and clicking the icon.
Infobridge, Inforiver, and Editable can now work together with client-side Web Application Firewalls (WAF) to stay secure. .
