Home > OLAP Dialog Boxes and Wizards > Build: Data Refresh Methods
![]() Previous |
![]() Next |
The Data Refresh Methods page identifies the cubes and dimensions included in the build, the preferred build method, and the build specification that defines the steps of the build.
Object Name: The name of a dimension or cube included in the build.
Object Type: Either Cube or Cube Dimension.
Load Options: Controls how the dimension is updated during the build, when the source data has changed.
Synchronize: The dimension members match the source dimension values exactly.
No Synchronization: Dimension members may be added or modified but not deleted.
Retain Parentage: Dimension members may be added or modified, but the parent relationships cannot change. Members are not deleted.
Sort: Sorts dimension members as specified on the Dimension General page. Otherwise, the sort order is not calculated. For very large dimensions containing millions of members, the sorting time may noticeably increase maintenance time. If you change the Sort option from Yes to No, any previously calculated sort order is deleted. Time dimensions are always sorted, and the sort is based on the end date attribute.
Refresh Method: The method used to refresh and aggregate the data. The list contains only those methods applicable to a particular cube. OLAP uses the selected method, but will revert to a different method if necessary to complete the build.
Choose from among these methods:
Complete: Clears all data from the cube, then loads and aggregates all the data from the source tables. All cubes can use this method.
Force: Uses the Fast method if possible; otherwise, it uses the Complete method.
Partition Change Tracking: Clears, loads, and aggregates only the values from an altered partition in the source tables.
Fast Solve: Loads all the detail data from the source tables, and then aggregates only the new values. Compressed cubes can use this method.
Cube Build Specification: Lists the available cube build specifications, from which you can select one to use for this build. The selected build specification can affect the available methods.
Related Topics