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. Create a scenario
  • 1.1. General
  • 1.2. Permission
  • 2. Create a scenario in reading view mode
  • 3. Configure scenario
  • 3.1. Create scenario
  • 3.2. Scenario settings
  • 3.3. Input method
  • 3.4. Bulk editing a scenario
  • 3.5. Show variance
  • 3.6. Slider settings
  • 3.7. Copy to base scenario
  • 3.8. Edit/duplicate/delete
  • 3.9. Set a default scenario
  • 3.10. Style formatting scenarios
  • 3.11. Exiting scenario mode

Was this helpful?

  1. Working with Inforiver
  2. 7. Planning, budgeting & forecasting

Scenarios (Writeback Matrix only)

PreviousGoal SeekNextBudgeting & allocations

Last updated 2 months ago

Was this helpful?

Inforiver Writeback Matrix offers the ability to create new scenarios in edit and read modes based on an existing series for ad-hoc analysis. Once a scenario is created, you can either simulate or perform allocations on the native measures.

Scenarios are interactive and can be edited unless it’s explicitly locked. They can be created in both reading and edit mode and can be shared with other users. You can writeback all or specific scenarios and enable automatic writeback if required.

1. Create a scenario

To create a scenario you need to log in with your Microsoft 365 account

You can create a new scenario by clicking the 'Create scenario' button under the 'Insert' tab of the Inforiver toolbar.

Clicking this option will open up a 'Create scenario' modal. This modal has a general tab and a permissions tab.

The general and permission settings can be edited later after the creation

1.1. General

Under the 'General' tab, you can configure the general scenario options and properties. You will find the following two options under this tab:

Scenario name - In this input field, you can specify the name of the scenario

Include series in scenario -This field by default has all the metrics added. You can however add or exclude the series you want in your scenario.

Start period and End period - Here you can specify the starting and ending periods of the scenario

Period Range - When you have a date dimension in your report columns, you will be able to create different scenarios corresponding to targeted time periods. You can select the time frame from the Period Range date picker.

1.2. Permission

Under the 'Permission' tab, you can configure the scenario permissions.

In the Who can share the scenario section, you can see the following two options:

i) All users within your company domain - If this option is selected, then all the users within your company domain will be able to share the created scenario

ii) Specific users within your company domain - Selecting this option will allow only the specified users to share the created scenario. If this option is selected, the 'Add users' input field becomes available. You can specify the email id of the people who can share this scenario in this input field.

Once all the permissions and settings are configured, click 'Create' to create a scenario.

2. Create a scenario in reading view mode

Creating a scenario in reading view mode follows the same procedure as the edit mode.

3. Configure scenario

If a new scenario is successfully created, you will see a 'Scenario' ribbon in the Inforiver toolbar.

The scenario tab has the following options to configure the scenario-related settings:

3.1. Create scenario

Alternatively, you can click the '+' icon next to your current scenario tab to create a new scenario.

3.2. Scenario settings

This option lets you edit the previously configured scenario settings. Clicking this option will open up the 'Edit scenario' modal.

In this modal, you can configure the general and permission settings.

If you want to lock your scenario, enable the 'Lock scenario' checkbox. A locked scenario cannot be edited.

3.3. Input method

Inforiver offers two types of input methods: simulation and distribution.

a) Simulation

b) Distribution

3.4. Bulk editing a scenario

You can also run simulations in bulk for a scenario you have created, allowing you to easily perform analyses like determining the impact of an x% increase in sales for a specific region or increasing the bonus for employees in a specific department by x dollars.

  1. In a scenario, click Bulk Edit from the tool bar under the Insert tab.

  2. In the pop-up, choose the measure to be simulated and the necessary categories and sub-categories from row and column dimensions.

  3. Select the simulation percentage to be applied and click Apply.

The animation below illustrates the same, with bulk simulations performed for two different scenarios and the results compared.

3.5. Show variance

If you enable this option, you will see the percentage of variance to the left of the data metrics.

3.6. Slider settings

If you click the 'Slider settings' option, the 'Variance settings' modal will open up.

This modal has the following options:

a) Series - Displays the name of the series in the scenario

b) Increase is good - This toggle is enabled by default. If this is turned on, then the percentage increase will be displayed in green. If this option is disabled, then the increase in value or percentage will be displayed in red.

c) Value range - In this field, you can configure the maximum value of the range. The default is 100%.

3.7. Copy to base scenario

You may perform simulations on different scenarios before arriving at the most optimal option. Any simulations on Data Input measures/columns in a scenario can be updated to the base scenario using the Copy to Base option.

On selecting Copy to Base, a dialog box opens up which contains the list of columns that will be exported.

On clicking on the Proceed button, the simulations in the scenario for 2023 Forecast have now been updated in the report.

You can also use the Copy to Base option in the toolbar to apply simulations to the base report.

3.8. Edit/duplicate/delete

To edit, delete, or duplicate a scenario, click on the additional options menu icon that appears when hovering over the name of the scenario and select the relevant option.

3.9. Set a default scenario

When users open scenarios in reading mode, the Base scenario is always displayed by default. If you want a particular scenario to be loaded on initialization, choose the Make as Default option from the context menu.

3.10. Style formatting scenarios

The image below shows Scenario 1 created from Base.

To copy the style formatting from the base or any other scenarios, select the format painter and choose Copy style formatting from scenario -> Base or select any Scenario name to copy its style.

The image below shows Scenario 1 with the style format copied from the Base.

3.11. Exiting scenario mode

You will be able to use the other ribbons like the Home/Insert/Design/Export while working on a scenario. The simulations applied to a scenario will be visible even when you navigate to any of the other toolbar tabs.

Click on the Close Scenario button to exit scenario mode. You just need to navigate to the Scenario ribbon to re-visit the scenarios you created.

But there is one additional step, you need to enable the 'Scenario tab' in the 'Allowed User Controls' modal. You can learn more about configuring the allowed user controls modal .

This option lets you create a new scenario. Clicking on this option will open up the 'Create scenario' modal. You can learn more about how to create a scenario .

If you choose the simulation input method, each cell will have a . You can calibrate the slider to adjust the value and simulate changes. Once simulations is performed, you can track them below the toolbar.

Using this method you can the value across descendants.

In the below scenario, the measure 2023 Forecast is created by to the report. The simulations on the 2023 Forecast in Scenario2 will be reflected in the report after selecting the Copy to Base option.

Scenario 1 will be opened by default in reading view when users navigate to scenarios. Default scenarios can be identified by the icon.

You can manually format the newly created scenarios using the or the as well as copy the style from the Base or any other existing scenarios.

In the next section, we'll look at .

here
distribute
budgeting and allocations
here
cell and value formatting styles
simulation slider
adding a new measure
column styles
Create scenario option
Period range for scenarios
Enable scenario tab in reading view mode
Scenario tab
Create scenario option
Create scenario icon option
Scenario settings option
Edit scenario modal
Lock scenario option
Input method option
Simulation option
Distribution option
Bulk editing scenarios
Show variance option
Variance settings modal
Copy to Basie
Copy to Base Modal
Report with values set up in a scenario
Copy to base option in the toolbar
Edit/duplicate/delete scenario
Make as default option
Default scenario in reading view
Scenario 1
Copy style formatting from scenario
Scenario 1 with the Base Style format
Navigating to the Insert ribbon in scenario mode
Close scenario