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) |
WritebackMatrix | 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 |
WritebackMatrix | 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 |