Home > OLAP Dialog Boxes and Wizards > Create/Edit Cube: Build Spe...
![]() Previous |
![]() Next |
A build specification consists 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 build specifications named LOAD_AND_AGGREGATE
and SYS_DEFAULT
.
Build Specifications
Lists the build specifications defined for the cube.
Click the Add icon to add a new build specification.
Click the Delete icon to delete the selected build specification.
To change a build specification, select it and change the values in the Build Commands.
Build Specifications
Default: Identifies the script as the default for the cube. The initial default script loads data into all the measures and aggregates it.
Name: The name of the build specification. Select the one you want to modify.
Build Commands
Either double-click or drag-and-drop a build command onto the build specification. Most commands display a template that provides a choice of options. You can use the templates to customize the command:
Expression Editor
Displays the selected build specification. You can enter code directly into the editor or use the templates provided by the Build Commands list.
A new build specification begins with this structure:
BUILD SPEC name(
LOAD
)
The expression editor provides the following tools:
Icon | Description |
---|---|
![]() |
Reverses the last change (undo). |
![]() |
Reapplies the last change after it is reversed (redo). |
![]() |
Copies the selected text to the clipboard and deletes it from the text area (cut). |
![]() |
Copies the selected text to the clipboard (copy) |
![]() |
Copies the contents of the clipboard to the text area (paste). |
![]() |
Erases the entire contents of the text area. |
![]() |
Merges the entire contents of the text area into a single line. All formatting is discarded. |
![]() |
Checks the syntax of the selected text. |
Syntax: Dynamically displays Valid or Invalid for the syntax shown in the text area.
Related Topics
Generates optimizer statistics. These statistics are used for queries against joined cubes or a cube joined to a table or view, but not queries against a single cube.
Prepares the cube for a data refresh by setting all or some of the values of a cube to null (NA).
Clearing all leaf values means that all facts must be reloaded, and the aggregates for any new or changed facts must be computed. However, the aggregates are not recomputed for leaf values that stay the same.
Clearing all aggregates means that all aggregates must all be recomputed.
Refreshes cubes and dimensions from the source data, using either parallel or serial processes.
Executes an OLAP DML command or program, using either parallel or serial processes. This command provides the basic syntax for executing DML commands. You must enter the OLAP DML between the single quotes in the EXECUTE
clause.
Executes a PL/SQL procedure or script. This command provides the basic syntax for executing PL/SQL commands during a build. You must enter the PL/SQL between the single quotes in the EXECUTE
clause.
Aggregates the measures of the cube, using either parallel or serial processes.
Runs one or more commands over a group of measures instead of all the measures in the cube. Click the list of measures in the template to display the Measure Selection dialog box. All measures in the cube are in the initial list.
This command provides the basic structure of a FOR loop in PL/SQL for you to edit.
Run the following command(s) for these measures: list of measures and all dimension members.
Template: Run the following command(s) for these measures: UNITS_CUBE.SALES, UNITS_CUBE.UNITS and all dimension members.
Build Syntax:
FOR /*Start of any comma delimited dimension member conditions here*/ /*If no conditions are present for a particular dimension, */ /*the default is apply to all members of that dimension*/ /*End of any comma delimited dimension member conditions*/ MEASURES(UNITS_CUBE.SALES,UNITS_CUBE.UNITS) BUILD( /*Add non-group and non-dimension member condition build commands here*/ /*The build commands must be delimited by commas.*/ LOAD )
Sets the criteria for dimension members to be included in the build. Select the dimension first, and then select the criteria.
Select {all members | none of the members | all members at the level(s) | members by condition} in dimension name.
This template displays the Levels dialog box when you click the levels, so that you can easily select the ones to use. All levels defined for the selected dimension are initially selected.
Template: Select all members at the level(s) TIME.FISCAL.QUARTER, TIME.FISCAL.YEAR in dimension TIME.
Build Syntax: "TIME" LEVELS(TIME.FISCAL_QUARTER, TIME.FISCAL_YEAR)