Several enhancements have been made to the OLAP Exchange® Rebuild Cube processing. First, the Rebuild Cube and Update Cube features have been merged into a single feature called Process cube. The Process Cube dialog box now has several new options for how the Cube gets rebuilt.
.png)
The new features for Cube rebuild reflect many scenarios allowing various optimized configurations for supporting Cube rebuild.
CONTROL |
DESCRIPTION |
Cubes |
List of all Cubes in the database that were created using OLAP Exchange |
Incremental Update |
Updates the Cube from trigger tables (must be Trigger Update cube) |
Update from Source |
Updates the Cube from the source tables setup via OLAP Exchange |
Meta Data |
Defines the metadata rebuild options |
No Updates |
No modifications are made to the Dimensions of this Cube |
Add Metadata |
Adds new Members from the source tables to the Dimensions |
Rebuild Metadata |
Adds new Members/deletes non-existing Members from the Dimensions |
Delete Members |
Deletes all Members from dims then rebuilds from source |
Rebuild Groups |
Rebuilds the Alias and Property groups that were created by OLAP Exchange |
Fact Data |
Defines the Fact Data rebuild options |
Full Rebuild |
Clears Fact data from Cube before re-loading all data from source tables |
Incremental Load |
Updates the Cube adding all values from the tables to the Cube |
Clear Table |
Clears the source measure table after an incremental load |
From Last Update |
Updates the Cube adding all values from last saved incremental ID |
Please see the following sub-topics: