WritebackTable
Defines the physical database table structure that receives modified analytical data when users perform writeback operations. Maps cube measures and dimensional attributes to specific database columns where user modifications are persisted. Required for cubes that support data modification through OLAP interfaces. Integrates with WritebackUtil for SQL generation and allocation policy processing.
Extends
Attributes
Name | Id | Type | Lower | Upper |
---|---|---|---|---|
name | false | EString | 1 | 1 |
Database table name where writeback data is stored. Used by WritebackUtil.commit() to generate SQL INSERT statements. Must contain columns matching the WritebackMeasure and WritebackAttribute definitions plus system columns (ID, USER). | ||||
schema | false | EString | 0 | 1 |
Optional database schema name qualifying the writeback table. When specified, used to construct fully qualified table names in SQL statements. Supports database environments requiring schema-based table organization. |
References
Name | Type | Lower | Upper | Containment |
---|---|---|---|---|
writebackAttribute | WritebackAttribute🔗 | 0 | ∞ | true |
Collection of dimensional attributes that will be included in writeback operations. Each WritebackAttribute maps a dimension's members to database columns in the writeback table. Used to maintain dimensional context when persisting modified measure values. | ||||
writebackMeasure | WritebackMeasure🔗 | 0 | ∞ | true |
Collection of measures that can be modified through writeback operations. Each WritebackMeasure maps a cube measure to a database column where modified values are stored. Supports allocation policies (equal, weighted, increment) for distributing values across atomic cells. |
Used by
- PhysicalCube🔗 → writebackTable