Reference Data Management

Self-service master/reference data management with approval workflow, audit and governance

Manage your master / reference / meta data for your reporting & planning applications. EDITable complements your Master Data Management (MDM) solution and requires minimal setup and assistance from IT. Supports data residing in Snowflake, Databricks, Azure SQL, Microsoft Fabric and Postgres.

Manage reference data in Power BI with audit & governance

Inforiver EDITable Reference Data Management

Watch demo
Try now

Key Features

Core Capabilities
Create a table from CSV/EXCEL
Edit table data (both measures and dimensions)
List of values lookup (from dropdown)
Field validation (email, phones etc.)
Setting default values
Field constraints

Bulk Edit
Bulk insert/bulk edit
Find, Search and Replace

Formatting/Themes
Layouts, conditional formatting and themes

Collaboration
Comments, threads, tasks, notifications

Data Integration
Advanced data integration (Webhooks)
Scripting extensions

Approvals
Table-level approval (Admin)
Conditional approval (Measure filter)
Row-level approval (Dimension filter)
Save mode (Persist with flag)

Slowly Changing Dimensions
SCD Type II support

Data Platforms and Storage
Azure SQL, Microsoft Fabric DW, Snowflake, Redshift, Postgres

Security/Governance
Audit/Change Log

Granular user activity permissions
Create table
Add rows
Delete rows
Edit/Replace rows
Field level view/edit permissions (Columnar ACL)

EDITable empowers integrated, real-time and collaborative planning (xP&A)

EDITable ensures that you easily manage reference data supporting your planning applications. Be it products, regions, accounts, cost centers, customers, employees or salaries - keep everything updated to ensure integrity of your plans and forecasts. Supports forward-looking master data that is needed for plans but is not yet created in your tables.

EDITable webinar

Watch our launch webinar on EDITable, a pioneering no-code live writeback product that empowers business users to create and manage reference data, dimensions, and flat tables.

Watch Replay

Writeback Matrix vs. EDITable

EDITable provides enhanced capabilities for maintaining flat tables, with support for Type 2 SCD, field-level permissions (columnar ACL) and more. Shown here is a brief comparison of Inforiver Writeback Matrix and EDITable.

	Writeback Matrix	EDITable
Structure	Matrix (Pivot table)	Tables, Type 2 Slowly Changing Dimensions
Edit/Update	Measures and Values	Dimensions and Values
Sample Use cases	Forecasting, budgeting	Dimensions, Price list, vendor list
Data Connectivity	Import & Live (Direct query)	Live (Direct query) only
Other	Source & destination tables are different	Source & destination tables are same

Writeback Matrix	EDITable
Structure
Matrix (Pivot table)	Tables, Type 2 Slowly Changing Dimensions
Edit/Update
Measures and Values	Dimensions and Values
Sample Use cases
Forecasting, budgeting	Dimensions, Price list, vendor list
Data Connectivity
Import & Live (Direct query)	Live (Direct query) only
Other
Source & destination tables are different	Source & destination tables are same

PowerApps vs. EDITable

EDITable is designed for business users with a no-code, Excel-like interface. Shown here is a brief comparison of PowerApps and EDITable.

Facet	Power Apps	EDITable
Target Persona	Developers	Business users
Development effort	Low code	No code / Self-service
Time to Market	High (weeks)	Low (minutes)
User Experience / Interface	Form-based and must be configured by usecases	Excel-like UX
Database Destinations	Best suited for Dataverse / Dynamics ERP	Best suited for data warehouses / data platforms / data bases
Bulk Edits	Best suited for single edits (insert/updates/delete)	Best suited for bulk insert / updates and single row or single cell edits
Workflows	Approval workflow has to be coded and complicated to build	Comprehensive approval workflow (by name, by rule and by look up)
Governance	Granular ACL is complicated and cumbersome to setup	Integrated and Granular row column ACL and audit / changelog

Power Apps	EDITable
Target Persona
Developers	Business users
Development effort
Low code	No code / Self-service
Time to Market
High (weeks)	Low (minutes)
User Experience / Interface
Form-based and must be configured by usecases	Excel-like UX
Database Destinations
Best suited for Dataverse / Dynamics ERP	Best suited for data warehouses / data platforms / data bases
Bulk Edits
Best suited for single edits (insert/updates/delete)	Best suited for bulk insert / updates and single row or single cell edits
Workflows
Approval workflow has to be coded and complicated to build	Comprehensive approval workflow (by name, by rule and by look up)
Governance
Granular ACL is complicated and cumbersome to setup	Integrated and Granular row column ACL and audit / changelog

Highlights

Build management, financial and variance reports in a few clicks

Leverage one-click business reporting templates

Deliver formatted financial statements

Deploy no-code paginated reports

Incorporate reporting & visualization best practices (e.g., IBCS)

Switch between tabular, hierarchical and stepped layouts

Create data-level annotations and footnotes

Insert calculated rows & columns

Write Excel-like conditional, logical and mathematical calculations

Design graphical tables with in-cell visualizations

Perform what-if simulations, forecasts and allocations

Export to PDF/Excel without losing formatting

Case Studies

Explore how Adapa streamlined planning across 21 centers with Inforiver, fostering collaboration and governance for faster, clearer insights.

Witness Ibex's shift from Excel forecasting to real-time data feedback, optimizing operations and fostering a data-driven culture.

Discover Merck's shift from Excel to Inforiver on Power BI for streamlined forecasting, elevating efficiency and decision-making for executives.

Top 10 Reasons why enterprises buy Inforiver

In this webinar, discover why customers choose Inforiver and explore recent enhancements, use cases and features through a live demo.

Watch Replay

top-reasons-why-enterprises-use-inforiver

Featured content

Get your FREE eBook

Forecasting multiple items with seasonality

Learn how you can quickly forecast multiple items with seasonality right inside Power BI!

[ebook_registration_form button_text="Send my free e-book"]

Have questions?

Get your questions answered by talking to our experts.

Inforiver BI Bundle

Analytics+

Reporting Matrix

Premium Table

Super FilterFree

Writeback Matrix

EDITable

EDITable

InfoBridge (Coming Soon)

Blogs

Documentation

Demos

Webinars

Community

Gallery

Videos

Ambassadors

Get Started

Skills Hub

Contact us

Partner program

eBooks

Events

Analytics+

Reporting Matrix

Premium Table

Writeback Matrix

EDITable

Analytics+

Writeback Matrix

Reporting Matrix

Appsource purchase

General

Products

Resources

Blogs

Documentation

Demos

Webinars

Community

Gallery

Videos

Ambassadors

Get Started

Skills Hub

Partner program

eBooks

Events

Pricing

FAQ

Analytics+

Writeback Matrix

Reporting Matrix

Appsource purchase

General

Reference Data Management

Self-service master/reference data management with approval workflow, audit and governance

Key Features

Core Capabilities

Bulk Edit

Formatting/Themes

Collaboration

Data Integration

Approvals

Slowly Changing Dimensions

Data Platforms and Storage

Security/Governance

Granular user activity permissions

EDITable empowers integrated, real-time and collaborative planning (xP&A)

EDITable webinar

Writeback Matrix vs. EDITable

WritebackMatrix

EDITable

WritebackMatrix

EDITable

Structure

Edit/Update

Sample Use cases

Data Connectivity

Other

Writeback
Matrix

Writeback
Matrix