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. View & filter subscriptions
  • 1.1. Subscription details
  • 1.2. Search bar
  • 1.3. Workspace
  • 1.4. Report
  • 1.5. Status
  • 1.6. Destination
  • 1.7. Subscription type
  • 1.8. Reset all
  • 2. Manage a subscription
  • 2.1. Summary
  • 2.2. Jobs
  • 2.3. Milestones
  • 2.4. Cancel parent job
  • 2.5. Re-run failed job
  • 2.6. Error Details
  • 2.7. Consents
  • 2.8. Export jobs
  • 2.9. Unsubscribe

Was this helpful?

  1. Working with Inforiver
  2. 11. Scheduling reports

Manage your subscriptions

PreviousReview & save subscriptionNextAdministration

Last updated 2 months ago

Was this helpful?

You can manage all your subscriptions from the Inforiver console.

Click on Manage subscriptions in an Inforiver report as shown below.

You can also access your subscriptions directly from the Inforiver Console.

1. View & filter subscriptions

The 'My subscriptions' page contains a list of all your subscriptions. For each subscription, the following details are displayed:

1.1. Subscription details

i) Name - The name of the subscription.

ii) Workspace - The name of the workspace in which the subscribed report is available.

iii) Report - The name of the report in the workspace.

iv) Owner - The owner of the subscription.

v) Next job - The date and the time of the next run.

vi) Last job - The date and time of the previous run.

vii) Status - This displays the current status of the subscription.

viii) Actions - The menu where you can perform the following options:

Run

Clicking on the play icon will open a 'Run now' modal. Click the Run now button to run the subscription instantly.

Pause

Click the Pause button in the modal to pause the subscription.

Delete

Clicking on the delete icon will open up a 'Delete' modal. Click the 'Delete' button in the modal to delete the subscription.

Here is a detailed breakdown of all the options available on this page. It has the following filter options to filter and narrow down your search:

1.2. Search bar

Using this search bar you can search for the subscription you need. If you have an enormous list of subscriptions this feature comes in handy.

1.3. Workspace

Using this drop-down you can filter the subscriptions based on the workspaces. Only the subscriptions of the selected workspaces will get displayed.

1.4. Report

Using this drop-down you can filter the subscriptions based on the reports. Only the subscriptions of the selected reports will get displayed.

1.5. Status

Using this drop-down you can filter the subscriptions based on their status. Only the subscriptions of the selected statuses will get displayed. This filter has the following options:

  • Active - This indicates all the currently running subscriptions and it is represented by a green dot

  • Paused - This indicates all the currently paused subscriptions and it is represented by a yellow dot

  • Locked - This indicates the subscriptions that are currently locked. A subscription is locked, if the scheduled destination is unavailable/removed.

  • Completed - If the schedule reaches the end date set during schedule creation, then it has a complete status and it is represented by a grey dot.

  • Archived - All the completed or paused subscriptions will be moved to the archived state after 90 days. The schedules in this status can't be run and can only be deleted.

Click on the 'More' option to view additional filter options for the scheduler. The additional filter options are 'Destination' and 'Subscription type'.

1.6. Destination

If you enable this option, a destination filter drop-down will appear, in which you can filter your subscriptions based on the destination type.

1.7. Subscription type

If you enable this option, a subscription filter drop-down will appear, in which you can filter your subscriptions based on the subscription type. The available options are highlighted below.

1.8. Reset all

Clicking on this option will reset all the applied filters.

2. Manage a subscription

2.1. Summary

Clicking on the name of any subscription on the 'My subscriptions' page will display all the subscription details in the report. By default, the 'Summary' tab is shown.

The following options are available at the top bar of this page:

  • Run now - Clicking on this icon will run the job subscription instantly.

  • Send test email - Using this option, you can send a test email to verify if the scheduled reports are being sent as expected and in the expected format. Clicking on this option will open up a 'Send test email' modal in which you can specify all the required details to send a test email and click on the send button.

  • Duplicate - Clicking on this icon will duplicate the chosen subscription

  • Delete - Clicking on this option will delete the chosen subscription

2.2. Jobs

This tab displays all the jobs for the selected subscription.

Clicking on the job ID will provide an overall summary of the job. The 'Run details' section provides detailed information about the scheduled job runs.

2.3. Milestones

A milestone represents the stages within the scheduled job progress. It consists of multiple levels, with each level providing a clear indication of the job's advancement to the user.

Sub-Milestones

Sub-milestones refer to a group of smaller activities or tasks that, when completed, collectively contribute to achieving an individual milestone. These sub-milestones help break down larger milestones into more manageable steps, tracking progress at a granular level while still contributing to the overall goal.

Milestone details for both legacy mode and current mode subscriptions are provided below. It denotes the indication and progress for all types of jobs, such as single jobs or a parent with multiple child jobs.

Milestones Details

Milestones & sub-milestones will be provided with a specified time stamp to track the duration of the process. It applies to various job flows, like single jobs and parent jobs with multiple job processing.

The 'Milestones' section contains step-by-step event flow of the scheduled run as follows:

1. Initial Job Data Setup

The system preprocesses the scheduled job configuration data to extract and organize the necessary information required to initiate the job. This includes:

· Job Initialization: Extracting key details from the pre-processed scheduled job configuration data to start the job execution process.

2. Refresh Data Service

This process handles refreshing the dataset based on the configuration:

· Refresh Execution: If the refresh dataset service is enabled, the system updates the dataset to ensure the latest data is used before proceeding with further tasks.

· Skip Condition: If the refresh service is not enabled, the dataset refresh step is skipped, and the process continues with the existing data.

3. Collect Page Visuals

The system processes embedding in a page-wise manner to ensure detailed tracking and configuration.

Key steps include:

i) Initiate Puppeteer Services

· Start the Puppeteer Service: Begin by activating the Puppeteer automation system to handle tasks like embedding a PowerBI report into the process.

· Embed the PowerBI Report: Use Puppeteer to include the PowerBI report, ensuring it is accessible for all further actions.

ii) Page Wise Dynamic Milestone

  • Checks for page Limit settings

  • Track Page-Wise Progress: As the system works through each page, it does the following:

> Takes a screenshot of the overall report page.

> Records the number of visuals processed on that page to meet the condition limit.

> Handles specific actions for each visual, such as, running preview services for a quick overview and exporting data to PDF or Excel formats based on needs.

iii) Combine and Merge Services

Combine and merge files:

For PDF or Excel files if merging is enabled,

  • Merge the multiple files as per destination and store them in the desired location.

  • If a layout is provided, organize the PDF into a grid format (including the report screenshot pdf file)

  • Deliver the final combined document to the designated destination.

iv) PPT Services

Generate PPT slides:

  • Use preview images generated for each page to create PowerPoint slides.

  • Once the slides are ready, a PowerPoint file is generated to the designated location.

Note: All outputs—PPT slides, PDFs, or Excel files—are securely saved to their respective locations for easy access.

4.Deliver Destinations

The system processes the selected destinations and their configurations to ensure seamless delivery of the generated files.

· Process Destination Configuration: Retrieve the scheduled subscription configuration to determine the destinations where the outputs need to be delivered.

· Deliver Attachments: Based on the configured destinations, send the generated attachments (PDFs, Excel files, PPT slides, etc.) to their respective locations.

2.4. Cancel parent job

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 Cancel Job option in the scheduler. This will immediately abort the subscription and cancel both the parent and child jobs without having to cancel each child job individually.

You’ll notice that the status of all your jobs is changed to Failed.

2.5. Re-run failed job

If a job run fails, then the 'Milestones' section has a 'Re-Run Job' button available at the top right corner of the section. Clicking on this option will rerun the failed job.

2.6. Error Details

For failed jobs, an additional section called 'Error Details' becomes available. This section contains information about errors that occurred during the job run.

The 'Error details' section has a 'Download logs' button at the top right corner of the section. Clicking on this button will download the error logs for the failed job run in a text file.

Here is a sample of a downloaded error log

Clicking on the 'Email' tab will display a list of all the recipients to which the scheduled job email was sent along with the delivery date, time, and delivery status.

You can also select any of the recipients by enabling the checkbox next to their corresponding email. If any of the checkboxes are enabled, then the 'Re-run job' button becomes available at the top-right corner of the page.

Clicking on this button will run the job only for the chosen email recipient.

2.7. Consents

This page becomes available only if the 'Refresh dataset' option is enabled during report creation.

If the 'Refresh dataset' option is enabled, then a consent email will be sent to the dataset owner emails mentioned during schedule creation.

This page contains a list of recipients who have accepted and not accepted the consent emails.

2.8. Export jobs

You can persist the status of your child job runs and save it to your desktop. Click the Export Jobs button to create an Excel extract.

2.9. Unsubscribe

This page contains a list of all the members who unsubscribed from the subscription along with the date of unsubscription.

To unsubscribe from receiving the scheduled report emails, click on the unsubscribe link at the bottom of the subscription email.

In the next section, we'll look at how to manage the subscriptions for .

workspace admins
Manage Subscription
Accessing subscriptions from the console
Run subscription
Pause subscription
Delete subscription
My subscription page
Search bar option
Workspace selection filter
Report selection filter
Subscription status
More filter option
Destination filter
Subscription filter
Subscription Summary
Options in the summary
Send test email
Duplicate subscription option
Delete subscription option
Jobs list
Job summary
Milestones
Collect Page Visuals
Cancel job option
Re-run a failed job
Download logs option
Downloaded error log
Email recipients list
Email re-run jobs
Consent email
Export jobs
Unsubscribe email
Unsubscription email