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 log filters
  • 2. Writeback log columns
  • 3. Exporting logs

Was this helpful?

  1. Working with Inforiver
  2. 12. Data writeback

Logs

Comprehensive and Searchable Writeback Logs

PreviousURL as destinationNextReading mode

Last updated 1 year ago

Was this helpful?

Inforiver offers milestone-based tracking as soon as the writeback button is clicked. There are multiple ways to view a comprehensive log of an ongoing writeback instance or previous writeback instances:

  • Click on Logs under the Export tab of the Inforiver toolbar.

  • Click View Log in the modal that opens upon completion of writeback.

  • Go to the Writeback Logs tab under the Monitoring section of the Inforiver console.

1. Writeback log filters

The writeback logs page allows us to search through writeback logs using several filter criteria. Let's explore each of these filters.

1.1. Search bar

In the search bar, users could search and filter writeback logs based on their ID, report, or environment.

1.2. Report

You can use the dropdown to select a particular report name.

1.3. Started by

You can use this filter to view logs based on the person who triggered the writeback. Select the person(s) from the list of users.

1.4. Environment

Use the drop-down to filter the writeback logs based on the environment from which writeback was triggered.

1.5. Destination

Use the drop-down to filter the writeback logs based on the writeback destination.

1.6. More - Status

Click on More and select Status to enable the dropdown. Use the below drop-down to filter the log based on the writeback status.

1.7. More - Event source

Select the Event source option under the More section - this will enable another dropdown that can be used to filter logs based on the writeback mode i.e. Writeback, Auto Writeback, or Reset.

1.8. More - Create time

Select the Start Time option under the More section - this will enable another dropdown that can be used to filter logs based on the writeback start time.

  • Within the last - If you select this option, you can specify the number of hours, minutes, or seconds. The logs will be fetched if the writeback start time falls within this period.

  • Last 7 days - Selecting this option will filter the logs within the last 7 days

  • Last 30 days - This option will filter the logs that were created in the last 30 days.

  • Between - If you select this option, then you can specify the starting and ending date within which you can filter your writeback logs.

1.9. Reset all

Clicking on this link will reset all the applied filters.

2. Writeback log columns

In this section, let's explore the columns in the writeback logs portal.

2.1. ID

This column displays a unique log ID that is used to identify the writeback log. You can sort the ID in ascending or descending order using the up/down arrows respectively.

Clicking on the writeback ID will open up a page with a detailed summary of the writeback.

Clicking the 'General' tab will display a summary of the writeback along with the milestones and their status.

The writeback log summarizes the following milestones:

i) Data processing

This indicates the events and steps that occurred during data processing. Click on the 'View events' link to view the data processing events in detail.

The data processing event, logs the performed action, the date and time the event was last updated, and the status of the event.

ii) Deliver to destination

This milestone displays the events logged while the writeback data was delivered to the destination. You can click on the 'View destination events' link to view the summary of the writeback destination, the date and the time at which the destination was updated, and the status of the writeback.

iii) Post processing

The post processing milestone indicates the events that occurred after processing the writeback. You can click on the 'View events' link to view the post processing action, the date and time the action was updated, and the status of the action/event.

Clicking on the name of the destination will display the connection details about the configured writeback destination.

2.2. Report

This specifies the report the writeback belongs to. You can sort the reports alphabetically in ascending or descending order using the up/down arrows respectively.

2.3. Destination

Destination(s) the data was written back to.

2.4.Duration

The total duration of the writeback.

2.5. Status

Shows whether the writeback succeeded or failed. You can sort the status alphabetically in ascending or descending order using the up/down arrows respectively.

2.6. Created at

The data and time at which the writeback was started. You can sort the created date in ascending or descending order using the up/down arrows respectively.

2.7. Started by

Name of the user who started the writeback. You can sort the user name in ascending or descending order using the up/down arrows respectively.

2.8. Scenario

Lists any scenarios that were written back. If there are no scenarios for writeback, the console will display 'Base'.

2.9. Writeback type

Specifies whether the writeback was in Long, Wide, Long with Changes, or Wide with Changes format.

2.10. Incoming cell count

Specifies the number of cells in your report that were written back.

2.11. Environment

The environment of the writeback. You can sort the environments in ascending or descending order using the up/down arrows respectively.

2.12. Event

Use this field to identify whether the log is for a regular writeback, auto writeback, or a reset operation.

3. Exporting logs

You can easily export the logs for a specified period by following the steps outlined below.

Step 1: Click on the export button at the top right corner to open the export dialog box.

  • Choose the format: CSV or Excel

  • Choose the period range: the default range is 30 days or you can set a custom range

If you choose a custom range, you can select the start and end dates from the calendar widget.

Step 2: Click Export. The status of the export will be displayed in the top right corner. After the export is complete, you can click the Download link to save the file to your system.

Step 3: Open the file to analyze the logs. You can quickly root cause and debug writeback failures with the Failure Reason column in the writeback log export.

Search bar
Report filter
Started by filter
Filter based on writeback environment
Destination filter
Status filter
Event source filter
Create time filter
Specifying a time range
Writeback log console
Writeback summary
Writeback logs export settings
Choosing a custom date range
Download logs
Writeback logs export