Inforiver
FormulaPricingProductAll Products
Reporting & Writeback Matrix Docs
Reporting & Writeback Matrix Docs
  • Introduction to Inforiver
    • Why Inforiver
    • Get Started
      • Installing Inforiver for yourself
      • Installing from AppSource
      • Installing Inforiver for your organization (Org visual)
      • Inforiver Writeback Matrix pre-requisites
        • Whitelist Inforiver IPs
        • Admin consent for Inforiver's Entra ID
          • Basic consent
          • Full admin consent
      • Inforiver Customer Portal
        • Billing Admin
          • Update Profile
          • Update Subscriptions
        • License Admin
      • Licensing
        • License renewal
      • Registering Inforiver on Azure AD (Entra ID)
  • Working with Inforiver
    • 1. Build your first Inforiver report
    • 2. Displaying information
      • Report interface
      • Layout options
      • Templates
      • Basic formatting
        • Number formatting
        • Cell, header & value formatting
        • Totals & subtotals
        • Insert blank rows
      • Basic inline charts
    • 3. Basic interactions
      • Explore & filter data
        • Search & Filter
        • Explorer
        • Top N + others
      • Sort & reorder data
      • Show/hide values
      • Manage column widths
      • Manage hierarchies
      • Create visual hierarchies
      • Pin rows & columns
      • Blend measures
      • Dynamic measure headers
      • Context menus
        • Column gripper
        • Row gripper
      • Actions
        • Rails
        • Toolbar options
        • Keyboard shortcuts
        • Reset
    • 4. Adding business logic and formulae
      • Insert calculated rows
        • Template rows
      • Insert calculated columns
      • Insert manual input rows
      • Insert manual input columns
        • Number
        • Dropdown
          • Dropdown options from semantic models
          • Lookup visuals for dropdowns
        • Text, checkbox & date
        • Writeback Matrix features
      • Invert sign
      • Editing cells
      • Quick formula
      • Visual column inside visual measures
      • Manage inserted rows
      • Manage inserted measures & columns
      • Pivot data
      • Insert image URLs
    • 6. Working with charts
      • Sparkline charts
      • Stacked charts
      • Bullet charts and clustered bar charts
      • Waterfall charts
      • Bar and pin charts
      • Change/deviation charts
    • 5. Conditional formatting
      • One-click options
      • Create rule
        • Rules (If conditions)
        • Color scale & data bars
        • Classification
        • Ranking
      • Manage rules
    • 7. Planning, budgeting & forecasting
      • What-if analysis & simulations
      • Goal Seek
      • Scenarios (Writeback Matrix only)
      • Budgeting & allocations
      • Forecasting
        • Date rollover and extending forecasts
        • Editing forecasts and reforecasting
        • Autoclose forecasts
        • Distribute deficit
        • Row level forecast
        • User Access Control
        • Common Scenarios
          • Forecast using a Blank Template
          • Forecast using Existing Data
          • Adding Forecasts for Periods unavailable in the model
          • Creating daily and weekly forecasts
      • Set version
    • 8. Paginated reporting
      • Pagination
      • Header & footer
        • Text
        • Images
        • Charts
        • KPI cards
      • Report layouts (Report+)
      • Display and themes
    • 9. Commenting and collaboration
      • Notes
      • Comments
        • Data-level comments
        • Assign & track tasks
        • Track changes
        • Report-level comments
        • Comment settings
    • 10. Exporting reports
      • Export to PDF & Excel
        • Excel export - operational boundaries
      • Ad-hoc emails
      • Snapshot (Writeback Matrix only)
        • Comparing snapshots
    • 11. Scheduling reports
      • Create new subscription
        • Select a report
        • Set subscription frequency
        • Select destination(s)
          • Email
          • OneDrive
          • Microsoft Teams
          • SharePoint
        • Review & save subscription
      • Manage your subscriptions
      • Administration
    • 12. Data writeback
      • Settings
        • General Settings
        • Data Settings
        • Destination Settings
        • Writeback security settings
        • Writeback time-out & batch size settings
        • Advanced Settings
      • Destinations
        • Azure SQL (Managed DB)
        • Azure SQL
        • Microsoft SQL Server
        • Synapse Dedicated SQL Pool
        • Azure Data Lake Storage
        • Databricks
        • Snowflake
          • Setting up Snowflake OAuth
        • Amazon Redshift
        • BigQuery
        • SingleStore
        • SAP HANA
        • Oracle
        • PostgreSQL
        • MySQL
        • OneDrive
        • SharePoint
        • Dataverse
        • Fabric Warehouse
        • Fabric lakehouse
        • Fabric SQL
        • URL as destination
      • Logs
      • Reading mode
    • 13. Context awareness
    • 14. Manage aggregation
      • Row aggregation
      • Column aggregation
    • 15. Managing Inforiver Writeback Matrix visuals
      • Inforiver deployments in Power BI pipeline setup
      • Duplicating Writeback Matrix Visuals - Best Practices
      • Recommended practices while working with Power BI desktop
    • 16. Approval workflows
    • 17. Collaborative adjustment workflows
    • 18. Variables
      • Variable types
        • Number
        • Select
        • Text
        • Date
        • Date range
        • Boolean
        • Button
      • Variable bookmarks
    • 19. Leveraging Power BI bookmarks
  • Admin Console
    • Manage Profile
    • User management
      • User Roles and Permissions
      • Create custom roles and policies
    • Settings
      • General
      • Generate builds - on prem
      • Forecast
      • Holidays
      • API token
      • Writeback
      • Managed DB
      • Assets
    • Onboarding actions
    • Writeback
  • Display settings
    • General settings
    • Hierarchy settings
    • Number settings
    • Miscellaneous settings
    • On-load scripting
  • Formula syntax
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
      • FILTERIF
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • AVERAGEIF
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • INDEXOF
      • LOG
      • ODD
      • MAX
      • MIN
      • NORMDIST
      • NORMSDIST
      • NORMINV
      • NORMSINV
      • PCT
      • POWER
      • RAND
      • RANDBETWEEN
      • ROUND
      • SORT
      • SQRT
      • SUM
      • PMT
    • Text formatting functions
      • CONCATENATE
      • HYPERLINK
      • LEFT
      • LOWER
      • MID
      • PROPER
      • REPLACE
      • REPT
      • RIGHT
      • TEXT
      • TRIM
      • UPPER
      • VALUE
    • Date functions
      • DATEADD
      • DATEDIFF
      • DAY
      • DATE
      • DATE.SET
      • DATE.FORMAT
      • SOWEEK
      • SOMONTH
      • SOQTR
      • SOYEAR
      • EOWEEK
      • EOMONTH
      • EOQTR
      • EOYEAR
      • NETWORKDAYS
      • ADDDAYS
      • ADDWEEKS
      • ADDMONTHS
      • ADDQTRS
      • ADDYEARS
      • FROMEXCELDATE
      • MONTH
      • NOW
      • PERIOD_RANGE
      • TODAY
      • TOEXCELDATE
      • YEAR
    • Time intelligence functions
      • AGGREGATE
      • FILTER
      • COLUMN_PERIOD
      • LASTNDAY
      • LASTNMONTH
      • LASTNQTR
      • LASTNYEAR
      • MONTHPERIOD
      • MOVINGAVERAGE
      • MOVINGSUM
      • MTD
      • NEXTNDAY
      • NEXTNMONTH
      • NEXTNQTR
      • NEXTNYEAR
      • QTD
      • QTRPERIOD
      • SHIFT
      • TOTALYTD
      • TOTALQTD
      • TOTALMTD
      • VALUEAT
      • YEARPERIOD
      • YTD
    • Other operators
    • Identifiers
      • CLOSEDPERIOD
      • COLUMN.DATE
      • COLUMN.PARENT
      • COLUMNS
      • CURRENT_PERIOD
      • DESCENDANTS
      • FORECAST.CLOSED_END
      • FORECAST.CLOSED_START
      • FORECAST.OPEN_END
      • FORECAST.OPEN_START
      • GROUP INDEX
      • HAS
      • HAS_ALL
      • HAS_SOME
      • LEAVES
      • LEVEL
      • LOGGEDIN_EMAIL
      • LOGGEDIN_NAME
      • MATCH
      • MAXDATE
      • MEMBERS
      • MINDATE
      • RELATIVE
      • RELATIVE_COLUMN
      • ROW.PARENT
      • ROW.LABEL
    • Scripting functions
      • DISPLAYTOAST
      • EXPORT
      • LAYOUT
      • SETCFRULE
      • SETFILTER
      • SETFILTERBYINDEX
      • SETVISIBILITY
      • SHOWBETWEENPERIOD
      • SHOWCLOSEDFORECAST
      • TOPN
      • DISPLAY SETTINGS
        • SETBLANKLABEL
        • SETSUPPRESSZEROS
        • SETRAGGEDHIERARCHY
        • SEPARATOR
        • SETCOMBINECOLUMNHEADER
        • SEMANTICFORMAT
        • SHOWNULLAS
        • SHOWZEROAS
        • SINGLECHILD
    • Miscellaneous functions
      • FETCH
      • LOOKUP
    • Measure/Column selection functions
      • GETCOLBETWEENPERIODS
      • GETMEASURE
  • Advanced topics
    • Audit log
    • Backup & restore report config
    • Enterprise themes
    • PowerPoint integration
    • Drill down and roll up in performance mode
  • Infobridge
    • 1. Create bridge
    • 2. Add source to bridge
    • 3. Bridge Interface
    • 4. Manage queries
      • Query transformations
        • Append
        • Join
        • Duplicate
    • 4. Manage sources
    • 5. Insert rows from bridge
    • 6. Insert measure from bridge
    • 7. Manage Integration of visuals
    • 8. Manage Bridges
    • 9. Data transformations
      • Pivot table
      • Group by
      • Add Column
      • Pivot column
      • Rename column
      • Find and Replace
      • Remove measure
      • Filter rows
      • Sort
      • Text functions
      • Unnest
      • Round
      • Extract Comments
      • Import and export
    • 10. Integrating forecasts
    • 11. Collaborative adjustments
  • Accessibility shortcut keys
  • Inforiver Reporting Matrix FAQs
  • Inforiver Writeback Matrix FAQs
  • Video tutorials
  • Resources
  • Release Notes
    • Inforiver Writeback Matrix May 2025 - v4.4.3
    • Inforiver Writeback Matrix April 2025 - v4.4.2
    • Inforiver Writeback Matrix April 2025 - v4.4.
    • Inforiver Writeback Matrix March 2025 - v4.3 - Time series formulae
    • Inforiver Writeback Matrix - March 2025 - v4.2
    • Inforiver Writeback Matrix March 2025 - v4.1
    • Inforiver Reporting Matrix March 2025 - V3.3.3 -New formatting and export options
    • Inforiver Writeback Matrix Feb 2025 - v4.0 - User permissions, High-performance mode, Input rules
    • Inforiver Writeback Matrix January 2025 - v3.9 - Fabric support, upgraded variables interface
    • Inforiver Writeback Matrix December 2024- v3.8 - Improved Scheduler Performance & Other Enhancements
    • Inforiver Writeback Matrix December 2024 - v3.7 - Merge rows, new rounding functions & More
    • Inforiver Writeback Matrix November 2024 - v3.6.2 - Import from Google Sheets & More
    • Inforiver Writeback Matrix October 2024 - v3.6 - Approval Workflows & Other Enhancements
    • Inforiver Writeback Matrix October 2024 - v3.5 - Lookup visuals & more
    • Inforiver Reporting Matrix Nov 2024 - v3.3 - Variables
Powered by GitBook
On this page
  • 1. Writeback type
  • 2. Filter
  • 3. Additional column configuration
  • 4. Permissions
  • 5. Webhooks
  • 6. Decimal Precision
  • 7. Text field length

Was this helpful?

  1. Working with Inforiver
  2. 12. Data writeback
  3. Settings

General Settings

PreviousSettingsNextData Settings

Last updated 22 days ago

Was this helpful?

Under the general settings tab, you can configure the general writeback settings which will be explored in this section.

1. Writeback type

Inforiver allows the user to choose the writeback table structure from a choice of 4 types.

i) Long

This is the default writeback type for any writeback table. The Tidy (long) type has one row per observation and one column per variable. Please note only the Tidy (long) type supports writing back Inforiver's comments and notes.

ii) Wide

This option stores the measures in the form of columns. As more measures are added, a proportional number of columns will be added to the writeback table to accommodate them.

Totals and subtotals will not be written back in the wide format.

iii) Long with changes

The Writeback with changes type also called "delta writeback" allows the user to record the changes/differences/adjustments made on a report during the writeback. If new data comes into the database, the old data is moved to a column called PreviousValue and the new data takes its place under the Value column. Inforiver also marks the IsLatest column=1 to indicate the latest row. Delta writeback works for both numeric and text data type adjustments.

iv) Wide with changes

This writeback type also performs a delta writeback - only changed records are written back. In this format, each measure is stored as a separate column in the database. Like the Tidy format, change history is maintained and the active record can be identified using the IsLatest column.

Writeback type considerations and best practices:

  1. Changing the writeback type of an existing table:

    • After an initial writeback has been performed, changing the writeback type will display a warning before unselecting existing tables in the Export -> Settings -> Destinations tab. Inforiver will not include them for writeback under this new/changed writeback type.

    • However, a user could go to Export -> Settings -> Destinations and (re)select table(s) to be included for writeback.

    • In this case, Inforiver will automatically detect conflicts between any existing table writeback type and the currently selected writeback type.

    • If there are conflicts, Inforiver will display a warning, seeking permission to drop and writeback. It is recommended to be sure before performing drop & writeback. If you are unsure, the best practice is creating a new table and performing writeback.

  2. Changing dimensions of report table: Adding new dimension categories will display a warning to the user seeking permission to drop and writeback.

2. Filter

The filter option allows the user to filter the data that is being written back to a destination. The filter dropdown list has a few presets readily available for the users.

a) None

This option will writeback the entire report/scenario without applying any filters.

b) Data with Comments

Only the cells that have a comment will be included in the writeback. Please note that 'Data with comments' only works in the Tidy(Long) writeback type.

c) Calculated rows only

Only the calculated rows (including the notes added in the calculated rows) are written back under this filter option.

d) Custom filters

Allows the user to define and set custom filter conditions. Inforiver allows a no-code filter creation experience that enables the user to set filter criteria for writeback with relative ease.

The Custom Filter configuration window has the following options:

  • Filter condition: This option allows you to create user-defined filter conditions. The filter condition requires selecting a dimension category, a logical expression, and the matching value of the dimension category. Inforiver has several built-in logical expressions to assist in building filter conditions.

You can writeback data based on the last updated date, for example, writeback only the data that was updated after, before, or on a specific date. Choose the ‘Last Updated At’ option in the custom filter type:

  • Add filter: This option allows you to add multiple filter conditions.

  • Combinators: AND or OR operators are available for filter logic creation.

  • Add group: Allows you to group filter conditions. This is useful when there are multiple filter conditions spanning multiple dimension categories.

  • Exclude Totals and Subtotals: Select this option to exclude the total and subtotals while writing back data.

Filter considerations:

  • If Power BI RLS is implemented, the recommended filter setting is to exclude totals and subtotals.

  • The Exclude Totals and Subtotals and Data with Comments filters will not be available for the Measure on Column writeback type.

  • The Data with Comments filter will not be available for delta writeback types.

If you have set up Matrix filters as well as writeback filters, the writeback filter will always take precedence.

3. Additional column configuration

This allows a user to add dimension keys to the writeback table during writeback. This will require the user to provide consent to access all the datasets from the workspace.

Inforiver allows you to add two types of following key columns,

  1. Add Dimension Key

  2. Add Date Key

Add Dimension Key

This allows the user to add key columns for dimensions (excluding datetime dimensions). For instance, each region or product will have an associated region ID or product ID (key) which you may not expose in reports. While writing back, you can include the region ID field as well.

The procedure is as follows,

  1. Select the dataset and dimension table that have the dimension category and dimension key

  2. Column: Choose the column from the table that matches your dimension category

  3. Visual Column: Choose the column in the Inforiver visual that matches your dimension category

  4. Additional column from the dataset: Choose the dimension key columns that will be included in the writeback table

  5. Column name in the writeback table: Set a custom name for the dimension key column to be included in the writeback table.

Add Date Key

This allows the user to add a date key column to the writeback table.

Inforiver reports are often used for high-level aggregations such as Revenue by Year-Months, etc. In such situations, the Add Date Key feature adds a Date Key column and writes values by appending the first day of the month or quarter to any high-level date dimensions. For example, If the report is set at Year-Month level. Inforiver adds 01-01-2023 for Jan'2023.

Additional Column Mapping and Best Practices

  • If a high-level dimension category is included in the visual and additional column mapping is chosen, Inforiver will write dimension keys only if there are no conflicts. In case of conflicts, writeback will go through successfully except that the dimension key columns will be written NULL. This will be recorded in the writeback logs. It is recommended that the user add appropriate categories to avoid conflicts.

  • Add Date Key only works with Power BI time intelligence generated date hierarchy set in the columns field of the visualization pane.

4. Permissions

The permissions option allows control over users who can writeback. It is possible to grant writeback permissions to everyone in your organization or to a select few users to perform writeback. Inforiver leverages Azure Active Directory (AAD), hence finding and granting writeback permissions to your co-workers will be straightforward.

a) All users within specific domains

Under this option, all the users within the specified organization will be able to configure the report writeback.

b) Specific users within the domain

Selecting this option will display an input field. Users can then specify the email addresses or names of the people within the team or organization in grant writeback permissions.

5. Webhooks

Inforiver webhook delivers a JSON payload to any HTTP endpoint. The JSON payload contains essential information about the writeback instance as shown below.

{
  "createdAt": 1704197364,
  "createdBy": "xxxxx@lumel.com",
  "details": {
    "destinations": [
      {
        "account": "DB account",
        "dataTableName": "DIM_KEY",
        "database": "INFORIVER_WB_DEMO",
        "databaseType": "snowflake",
        "destinationName": "Snowflake: DIM_KEY",
        "errorMeta": {},
        "message": "Data inserted successfully",
        "mode": "Managed",
        "numberOfRows": 72,
        "role": "IR_DEMO_USER",
        "schema": "IR_DEMO_SCHEMA",
        "status": "Success",
        "type": "Snowflake",
        "warehouse": "IR_WH"
      }
    ],
    "metaData": {
      "autoWritebackEnabledScenarios": [],
      "environment": "Desktop",
      "event": "Writeback",
      "isAutoWritebackEnabled": false,
      "reportUrl": null,
      "scenariosWrittenback": ["Base"],
      "writebackType": "Values in Measure on Columns Format"
    }
  },
  "error": [],
  "executionId": "WB170419736410403",
  "reportName": "Actuals, Plan by Region, Sub Region, Month",
  "status": "Success"
}

```

To set up Inforiver Webhooks, paste the HTTP endpoint URL in the URL field. Click the 'Add new header' link to add a new header. In the header, add the key-value pair. When writeback is initiated, Inforiver will deliver its JSON payload to the configured endpoint.

It is possible to initiate and trigger further workflows using the Inforiver webhook. A few examples are as follows

  • Approval workflow using Power Automate Microsoft Teams

  • Refresh Dataset/Dataflow workflow using Power Automate

6. Decimal Precision

You can specify the number of digits after the decimal point to be written back. This is a one-time setup that will apply to all destinations configured for a particular report page. While configuring the first writeback destination, you will see a pop-up as shown below, to configure the decimal precision.

If you require high precision, you can configure Inforiver to write back numerical data with up to ten decimal digits. Any digits beyond 10 will be rounded off.

7. Text field length

The text length that has been set is shown in the Text Length section of the report as below. Note that, if you have restricted the text length and the length exceeds that limit, writeback will fail.

You can retain while writing back data. If you have applied any visual filters, when you trigger a writeback, you will be prompted to choose between writing back all the data or filtered data only.

The above are sample workflows that could be triggered using the Inforiver webhook. There are many other workflows possible. Please note that the Inforiver webhook is different from URL as Destination. Inforiver webhook's JSON payload only contains essential information about the writeback table. URL as Destination JSON payload contains the entire writeback table. Learn more .

The precision that is set in the destination configuration is displayed in the Decimal Precision section. .

You can restrict the length of text fields to be written back. The default text length allowed in writeback is 512 characters. While adding the first destination, along with , you can also restrict the length of text fields to 512 characters or allow writeback up to the maximum limit supported by the backend. This is also a one-time setup that will apply to all destinations configured for a particular report page. .

Matrix filters
here
Learn more about configuring writeback destinations
Learn more about configuring writeback destinations here
decimal precision
Writeback types
Inforiver Tidy (long) writeback type
Inforiver Measure on columns writeback type
Delta writeback in Tidy format
Custom filters
Custom filter condition
Writeback filter based on last update date
Configuring decimal precision
10-digit decimal precision
Decimal Precision
Configuring text field length
Long text field truncated