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. Insert data input row
  • 2. Bulk insert static rows
  • 2.1. Inserting child rows
  • 2.2. Inserting a hierarchy
  • 2.3. Disabling row insertion
  • 2.4. Uploading from an Excel sheet
  • 2.5. Insert rows from semantic models
  • 2.6. Setting user permissions
  • 2.7. Allow blank values in categories
  • 3. Row hierarchy
  • 4. Merge rows

Was this helpful?

  1. Working with Inforiver
  2. 4. Adding business logic and formulae

Insert manual input rows

PreviousInsert calculated columnsNextInsert manual input columns

Last updated 2 months ago

Was this helpful?

Quite often we would like to insert a row in our table/matrix reports in Power BI and enter our own data. For example, a financial statement report connecting to a database query may be able to fetch revenue & expense metrics, but it might not retrieve the number of shares outstanding. Similarly, a sales report can leave out the sales data for a newly launched product category.

To address such scenarios, Inforiver allows you to insert static rows in matrix-style reports where you can input or enter the data.

1. Insert data input row

You can insert data input rows from the Insert tab > Insert Row menu. Please bear in mind that the Insert Row button will be disabled until you select a row in your report. Select the Number option from the Data Input sub-menu.

Another way to insert static rows is by using the row gripper. The gripper icon is highlighted when you hover over a row. Click on it, then select the Insert > Data Input option.

1.1. Data input row properties

A side panel opens when creating a data input row. Type in the name of the category in the Title textbox and click Create. You will see an empty record created above the row that was selected.

i. Row type

Create a calculated row, data input row, or aggregated row by selecting the appropriate option from the dropdown.

You have the flexibility to switch between data input, calculated, and aggregated rows at any time with the 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.

iii. Insert as

Select the Single Row option to insert one data input row. Select the Templated option to replicate the row category 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.

The image below shows how template rows are rendered.

iv. Scaling factor

You can set the scaling factor for the static row depending on the data that is expected to be entered. It is set to Auto by default.

v. Include in total

When the 'Include in total' option is enabled, any values we type in for the new row also contribute to the parent row, in this case, 'Canada'.

iii. Distribute parent value to children

The 'Distribute parent value to children' option ensures that if a value is entered at a total level, it gets distributed to the levels below it.

iv. Bind for cross filter/RLS

v. Default value

You can either enter a static value or select another row to source default values.

1.2. Delete a static row

To delete a static row, hover over the row and click on the row gripper. Select the 'Delete Row' option. You can also delete rows from the Manage Rows interface that will be covered in subsequent sections.

2. Bulk insert static rows

You can bulk-insert leaf-level rows or hierarchies using the Insert rows option.

2.1. Inserting child rows

To insert a leaf-level row, click on any child row or the parent row under which you want to create rows. From the row gripper, select the Insert Rows option. Notice that the parent category is already populated. You can key in the value for the child rows.

There are 2 ways to add new rows:

  • Click Add New, then choose whether to insert a single row or bulk insert 5/10 rows.

2.2. Inserting a hierarchy

To insert a new level in an existing hierarchy, you can overwrite the default parent category that is auto-populated in the Insert Rows window. For instance, if you click on United States (or any child row), the Insert Rows will automatically have United States as the Region. Double-click and overwrite the value with the desired parent category.

2.3. Disabling row insertion

You can restrict users from creating new categories for a particular level. Navigate to Insert >Manage Rows > Row Settings> Insert Row Configuration.

We’ve disabled the creation of new regions. However, new subregions can still be inserted.

Notice how the Region textbox is disabled in the Insert rows window but we are able to enter values in the SubRegion textbox.

If you have hierarchical row dimensions, when you disable row insertion for a specific dimension, this will automatically disable row insertion for all levels above it.

2.4. Uploading from an Excel sheet

You can upload the row categories from an Excel sheet. In the Insert Rows window, you will be able to see the data from your Excel as dropdown options. Let's see how.

STEP 1: Navigate to Insert >Manage Rows > Insert Row Settings> Insert Row Configuration. Select Options list from CSV from the dropdown.

STEP 2: On selecting the option, The Add Options from CSV window opens. Click the Upload button. You can browse and upload the source file from the CSV Upload tab. Inforiver displays a preview of the contents of the CSV file.

STEP 3: You need to map the source field from the Excel which will be used as row categories. Choose the field from the Excel from the Label Column dropdown. In this case, the mapping is as shown below:

Excel Column
Visual Row Category

Sector

Region

Country

Sub Region

STEP 4: You will need to set up filters if you want to map subcategories under the respective parent category. In this case, when you select Frontier markets as the Region, you would only want to see Vietnam, Romania, and Kenya in the Sub Region dropdown. Similarly, when you select CIVETS as the Region, you would only want to see Colombia, Indonesia, Vietnam, Egypt, etc, and none of the countries that fall under the Frontier markets sector.

Once the steps discussed above are completed, you will be able to see the data from your Excel in the Region and Sub Region dropdowns.

Follow the steps discussed in sections 2.1/2.2 to insert the configured row categories into your visual.

2.5. Insert rows from semantic models

STEP 1: To pick and upload row categories from a semantic model, navigate to Insert > Manage Rows > Insert Row Settings > Insert Row Configuration > Manage. Select Options list from Semantic Model from the 'Category' dropdown.

STEP 2: The Add options from Semantic model window opens. In the Table Connection tab, select the workspace, semantic model and the table you need to connect to. Click Next.

STEP 3: Go to the Options configuration tab and choose the column from the connected table that will be used as the option label. In the example below, we have chosen the column 'Category' from the table 'Contoso-Product'. This column's members will be used to populate the 'Categories' row level. STEP 4: You can optionally specify a filter if hierarchical data is involved, and you want to maintain the same structure in your reports. In the Columns dropdown, select the field based on which you need to filter the options. In this case, it is the Contoso - Product.SubCategory which can be used to identify the Category. Select the matching field from the visual (SubCategory) in the Visual Column dropdown.

Then click Add.

Because of this filter, when you insert a row and add a sub-category first, you will be prompted with the category to which it belongs.

Configuring filter options is optional. By adding it, we ensure that the dropdown list for each category displays only the relevant sub-categories and vice-versa. For example, if you choose "Cellphones" as the category, only the sub-categories under "Cellphones" will be displayed, not other categories.

Similarly, when you choose a sub-category, you can add it only under the relevant category.

STEP 5: Follow the same steps from 1 to 4 for SubCategory dimension.

Once the configuration is completed as shown in the image above, you can follow the steps in sections 2.1/2.2 to insert the configured row categories into your visual.

You will see the data from the semantic model in the Category and Sub Category dropdowns.

The rows are inserted as shown below:

2.6. Setting user permissions

You can explicitly set permissions for users to insert rows in read mode. You have options to restrict all users, allow all users, or authorize specific users to insert rows. Navigate to Insert > Manage Rows > Row Settings > Insert Row Access to set permissions.

  • Enable the Allow in Read Mode toggle to allow users to insert rows in reading mode.

  • To allow all the members in your organization to insert rows, choose the All users radio button.

  • If you want to restrict users from inserting rows, choose the Specific users radio button. You will then be able select the users to whom you want to provide access.

2.7. Allow blank values in categories

While inserting row hierarchies manually, you can enable the Allow Blank Values toggle if you expect blank row categories in the leaf nodes. This option is available at Insert tab > Manage Rows > Row Settings > Insert Row Configuration > Manage.

By default, this toggle is disabled. The blank categories are highlighted in a red error box, and Inforiver prevents you from inserting rows.

By enabling this option, you can insert row hierarchies that contain blank leaf categories. In the image below, notice that the Corporate segment has only one product and does not have any discount bands under it. Similarly, the Consumer segment does not have any products or discount bands tagged to it as the row categories were left blank while inserting rows.

Please note that you cannot create blank parent nodes for child nodes that are not blank.

3. Row hierarchy

This option can be used to insert a single user-defined level for hierarchical data. Only one row is created while using this option, unlike the Insert Rows(s) option, where you can define the hierarchy structure with multiple nested levels and rows.

After creating a custom hierarchy level, you can insert static rows, calculated rows, aggregated rows, etc. as demonstrated in the example below.

4. Merge rows

Data input fields will be locked for editing until the row is merged.

Notice how the merge icon disappears and the data input field becomes editable after merging the EURIBOR row. When you merge rows, static rows are replaced with native rows however data inputs are retained.

Resources

You can enable the Bind for Cross filter/RLS option – this ensures that cross-filter selections and RLS settings apply to calculated/manual input rows that reference other rows. For example, if this option is not enabled, a manager handling Canada accounts can view a manually inserted row that references US data or an inserted region that is manually created at the visual level.

To insert a new row, click the icon that appears on hovering near the parent category.

The TJOrg, HDTabmble, and DC rows are created when you click Save. You can enter values in these rows. The icon denotes manually inserted rows.

You can also insert rows and their leaf categories from semantic models. The procedure is similar to .

The base data in our visual may be from one table, but the options in the dropdown may be from a different table; in such cases, you can specify a join. For more information on using joins and filters, please refer to .

You may be expanding to new regions or adding new product lines - with the , , and options, you can add dimension categories on the fly. When the same category exists at the visual level and in your semantic model, you will be able to merge the rows from your dataset.

The icon that indicates a manual input row will be replaced bywhen a row dimension category is available in the source system. Click the icon to merge the row and then click Proceed in the Merge rows dialog box.

In the next section, we'll be looking at .

Static Row
Insert Rows(s)
Row Hierarchy
inserting manual input columns
Insert row and manually enter data in Power BI matrix reports
Learn more about binding rows.
adding single and multi-select options from the semantic model
this section
Data input - Number
Inserting data input rows from the gripper
Data input row created
Row type
Template rows
Static default value
Default values from another row
Deleting a static row
Insert rows option
Bulk insert row categories
Entering values for data input rows
Inserting a hierarchy level
Disabling row insertion
Row insertion disabled at a specific level
Automatic row insertion disabled for higher levels
Option to source data from Excel
CSV Upload
Selecting the source field
Creating a filter to map subregions to parents regions
Data from Excel populated in the Insert Rows window
Row categories sources from Excel
Options list from semantic model
Table Connection
Options configuration
Options list from semantic model
Options Configuration
Configuration done
Insert rows from semantic model
Inserted rows
Insert row permissions
Enable 'Allow Blank Values'
When toggle is disabled
Row hierarchy with blank categories
Add a new level to the hierarchy
Merge rows dialog box
Merged row