A cube scripts consist of one or more ordered steps that prepare a cube for querying, such as loading detail data and generating aggregate data.
Each cube has a default cube script named SYS_DEFAULT. This is the only script for cubes enhanced as cube materialized views.
Name
A simple name.
You cannot change the name after creating the script.
Default Script for This Cube
Select this option to identify the script as the default for the cube. The initial default script loads data into all the measures and aggregates it.
Cube Script
This table identifies the steps in the cube script.
Step: Identifies the order in which the steps are executed during a build. To change the order, select a step and click the up- or down-arrow.
Type: Identifies the type of step, such as Load or Aggregation.
Status: Identifies whether the step has been fully defined.
New Step
Displays the New Step dialog box for the selected step type. Choose from the following:
Clear Data: Sets the values of a dimension or a cube to null (NA).
Load: Refreshes cubes and dimensions from the source data.
Aggregation: Aggregates the selected measures using the cube rules. This step is available only for uncompressed cubes.
Analyze: Generates optimizer statistics. These statistics are not used for queries against a single cube.
New OLAP DML: Executes an OLAP DML command or program.
New PL/SQL: Executes a PL/SQL procedure or script.
Edit Step
Displays the Edit Step dialog for a step selected in the list.
Delete Step
Deletes the selected step.
Copyright © 2003, 2007, Oracle. All rights reserved.