Home > About Loading Data into Dim... > About Loading Data
![]() Previous |
![]() Next |
You can build an entire analytic workspace, or individual dimensions, cubes, build specifications, and measures. The build process does the following:
Analytic Workspace: Loads all cubes and dimensions and aggregates the data.
Cubes: Loads dimension members, attributes, and measures, and calculates the aggregate data using the default build specification.
Dimensions: Loads dimension members and attributes from their relational sources.
Measures: Loads data and calculates the aggregate data using the default build specification.
A build specification is an ordered list of steps that prepare a cube for querying. Each step represents a particular data transformation. By specifying the order in which these steps are performed, you can allow for interdependencies.
Each cube automatically has a build script named SYS_DEFAULT
, which loads the data and aggregates it using the rules defined on the cube. You can define any number of additional scripts and designate one as the default. All methods of refreshing a cube execute the default build script.
To automate routine data refreshes, you can use DBMS_CUBE
to create and populate an analytic workspace or to maintain any cube.
The following command initiates a complete refresh of UNITS_CUBE
, which is enabled as a cube materialized view. It automatically refreshes any stale dimensions before refreshing the cube.
EXECUTE dbms_cube.build('GLOBAL.UNITS_CUBE');
See Also: Oracle Database PL/SQL Packages and Types Reference for full details aboutDBMS_CUBE.BUILD . |