# Inforiver Writeback Matrix January 2025 - v3.9 - Fabric support, upgraded variables interface ## 1. Infobridge #### 1.1. Support for Fabric Lakehouse sources 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.

#### 1.2. Writeback to Fabric SQL destinations 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.

#### 1.3. Visual column support 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.

#### 1.4. Context-aware connected planning 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.

#### 1.5. Automatic retry for data preparation jobs 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.

#### 1.5. Measure and scenario selection interface You'll notice that the measure and scenario selection window has a more user-friendly interface.

## 2. Data input #### 2.1. Refined UI for data input rows \- 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.

#### 2.2. Parent rows as calculated rows 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.

#### 2.3. Disable insert row should not allow entry for parent dimensions 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.

#### 2.4. View logs and status of measure backups 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.

## 3. Variables 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.

## 4. Scheduler #### 4.1. Cancel parent job option 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.

#### 4.2. Export jobs 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.

## 5. Excel-like nested sorting 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.

## 6. Commenting and collaboration #### 6.1. Comments settings revamp 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. #### 6.2. Marker mode enhancements 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.

#### 6.3. Delete option in notes column You can delete a particular note in the Notes column by hovering over it and clicking the

icon.

## 7. Performance mode 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. ## 8. Audit log enhancements 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.

## 9. Visual formulas #### 9.1. Normal distribution formulae 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:

## 10. Formatting #### 10.1. Conditional formatting for charts 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.

Conditional formatting for inline charts

#### 10.2. Conditional formatting for row headers 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.

#### 10.3. Conditional formatting icons & text for date measures You can use icons and text to highlight date measures with conditional formatting.

#### 10.4. Icons in visual measures, columns, and rows 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.

Using symbols in measure and row headers

#### 10.5. Conditional formatting for data input fields 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.

#### 10.6. Scaling options for charts In the Customize tab, you have options to apply common scaling for all measures or individual scaling for each measure.

#### 10.7. Padding for stacked bar charts You can set custom padding between the stacks in a stacked bar chart.

#### 10.8. Is Blank/is not blank for non-numeric measures 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.

#### 10.9. Background for classification text 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.

## 11. Admin console #### 11.1. Date picker for Writeback logs filter You can use the handy date picker when you need to filter writeback logs between specific create time ranges.

## 12. Other enhancements #### 12.1. Sort icon upgrade When you sort measures from the column gripper, you'll notice that the sort icons have been upgraded to a more intuitive version.

#### 12.2. Refer to visual measures, simulations, and forecasts in headers 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.

#### 12.3. Custom date formatting for non-hierarchical dates You can now use custom date formats when you have non-hierarchical date fields in your dataset.

#### 12.4. Aggregation notification while converting to percentages 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.

#### 12.5. Ungroup and remove group in row gripper 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. #### 12.6. WAF compatibility Infobridge, Inforiver, and Editable can now work together with client-side Web Application Firewalls (WAF) to stay secure. [Learn more about WAF compatibility in Inforiver](https://docs.inforiver.com/inforiver-enterprise-on-prem/how-to-guides/application-gateway-integration#for-web-application-firewall-waf-support-you-must-consider-things-like). #### 12.7. Performance boost for allocations Significant performance optimizations will enable you to seamlessly distribute and allocate forecasts/data inputs for up to 1 million cells. #### 12.8. Unlock cells in the Read view 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. #### 12.9. Functions for Display Settings 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. #### 12.10. Search bar for scenarios and semantic models We've added a search bar to enable you to quickly locate dimensions while creating scenarios or fetching options from a semantic model.

#### 12.11. Semantic formatting from column gripper 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.

#### 11.12. Sign in headers for all templates The Sign in Headers option could be applied only to IBCS templates in earlier versions. You can now use it for all Inforiver templates.

#### 12.13. Enhancements to minimal with tabs toolbar 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: | FORECAST TYPE | MAXIMUM TIME RANGE | | ------------- | ------------------ | | 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.

## 13. Writeback #### 13.1. Enforce staging table if payload exceeds a threshold 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.

#### 13.2. Email notification for scheduled writeback failures An email notification will be generated when a scheduled writeback fails. --- # 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-writeback-matrix/inforiver-writeback-matrix-january-2025-v3.9-fabric-support-upgraded-variables-interface.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.