Skip Headers
Previous
Previous
 
Next
Next

About Loading Data

You can build an entire analytic workspace, or individual dimensions, cubes, build specifications, and measures. The build process does the following:

About Build Specifications

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.

About the DBMS_CUBE PL/SQL Procedure

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 about DBMS_CUBE.BUILD.