Inforiver
LoginTry for FREE

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

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 & governanceInforiver EDITable Reference Data Management

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

Approvals

Table-level approval (Admin)

Conditional approval (Measure filter)

Row-level approval (Dimension filter)

Save mode (Persist with flag)

Bulk Edit

Bulk insert/bulk edit

Find, Search and Replace

Slowly Changing Dimensions

SCD Type II support

Formatting/Themes

Layouts, conditional formatting and themes

Data Platforms and Storage

Azure SQL, Microsoft Fabric DW, Snowflake, Redshift, Postgres

Collaboration

Comments, threads, tasks, notifications

Security/Governance

Audit/Change Log

Data Integration

Advanced data integration (Webhooks)

Scripting extensions

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.
IntegrationsIntegrations

EDITable webinar

replay-introducing-editable

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

Writeback
Matrix

Editable

EDITable

StructureMatrix (Pivot table)Tables, Type 2 Slowly Changing Dimensions
Edit/UpdateMeasures and ValuesDimensions and Values
Sample Use casesForecasting, budgetingDimensions, Price list, vendor list
Data ConnectivityImport & Live (Direct query)Live (Direct query) only
OtherSource & destination tables are differentSource & destination tables are same
Writeback Matrix

Writeback
Matrix

Editable

EDITable

Structure

Matrix (Pivot table)Tables, Type 2 Slowly Changing Dimensions

Edit/Update

Measures and ValuesDimensions and Values

Sample Use cases

Forecasting, budgetingDimensions, Price list, vendor list

Data Connectivity

Import & Live (Direct query)Live (Direct query) only

Other

Source & destination tables are differentSource & 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

PowerApps

Power Apps

Editable

EDITable

Target PersonaDevelopersBusiness users
Development effortLow codeNo code / Self-service
Time to MarketHigh (weeks)Low (minutes)
User Experience / InterfaceForm-based and must be configured by usecasesExcel-like UX
Database DestinationsBest suited for Dataverse / Dynamics ERPBest suited for data warehouses / data platforms / data bases
Bulk EditsBest suited for single edits (insert/updates/delete)Best suited for bulk insert / updates and single row or single cell edits
WorkflowsApproval workflow has to be coded and complicated to buildComprehensive approval workflow (by name, by rule and by look up)
GovernanceGranular ACL is complicated and cumbersome to setupIntegrated and Granular row column ACL and audit / changelog
PoweApps

Power Apps

Editable

EDITable

Target Persona

DevelopersBusiness users

Development effort

Low codeNo code / Self-service

Time to Market

High (weeks)Low (minutes)

User Experience / Interface

Form-based and must be configured by usecasesExcel-like UX

Database Destinations

Best suited for Dataverse / Dynamics ERPBest 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 buildComprehensive approval workflow (by name, by rule and by look up)

Governance

Granular ACL is complicated and cumbersome to setupIntegrated 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

Featured webinar

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

forecasting-in-powerbi-feature-imageinforiver-user-license-example-pricingexisting-plan

Get your FREE eBook

Forecasting multiple items with seasonality

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

forecasting-multiple-seasonality

Have questions?

Get your questions answered by talking to our experts.

Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
Inforiver

Inforiver helps enterprises consolidate planning, reporting & analytics on a single platform (Power BI). The no-code, self-service award-winning platform has been recognized as the industry’s best and is adopted by many Fortune 100 firms.

Inforiver is a product of Lumel, the #1 Power BI AppSource Partner. The firm serves over 3,000 customers worldwide through its portfolio of products offered under the brands Inforiver, EDITable, ValQ, and xViz.

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram