Skip Headers
Previous
Previous
 
Next
Next

Create/Edit Cube: Build Specifications

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.

add icon

Click the Add icon to add a new build specification.

delete icon

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
Counterclockwise arrow icon
Reverses the last change (undo).
Clockwise arrow icon
Reapplies the last change after it is reversed (redo).
Scissors icon
Copies the selected text to the clipboard and deletes it from the text area (cut).
Two pages icon
Copies the selected text to the clipboard (copy)
Clipboard and page icon
Copies the contents of the clipboard to the text area (paste).
Pencil eraser icon
Erases the entire contents of the text area.
Right-justification icon
Merges the entire contents of the text area into a single line. All formatting is discarded.
Window and check mark icon
Checks the syntax of the selected text.

Syntax: Dynamically displays Valid or Invalid for the syntax shown in the text area.

Related Topics

"About Build Specifications"

Analyze

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.

Template

None

Example

Build Syntax: ANALYZE

Clear

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.

Template

Clear {all | leaf | aggregate} values of the cube using {parallel processes | a single process} for each cube partition.

Example

Template: Clear leaf values of the cube using parallel processes for each cube partition.

Build Syntax: CLEAR LEAVES PARALLEL

Load

Refreshes cubes and dimensions from the source data, using either parallel or serial processes.

Template

Load cube data using {parallel processes for each cube | a single process for each cube partition | only partitions with data} for all measures and all the rows from the tables.

Example

Template: Load cube using only partitions with data for all measures and all the rows from the tables.

Build Syntax: LOAD PRUNE

OLAP DML

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.

Template

Use {parallel processes | a single process} for each cube partition for all measures and for all dimension members to execute the OLAP DML.

Example

Template: Use parallel processes for each cube partition for all measures and for all dimension members to execute the OLAP DML.

Build Syntax: EXECUTE OLAP DML '' PARALLEL

PL/SQL

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.

Template

None

Example

Build Syntax: EXECUTE PLSQL ''

Solve

Aggregates the measures of the cube, using either parallel or serial processes.

Template

Solve cube using {parallel processes | a single process} for each partition for all measures and all dimension members.

Example

Template: Solve cube using a single process for each partition for all measures and all dimension members.

Build Syntax: SOLVE SERIAL

Group Command

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.

Template

Run the following command(s) for these measures: list of measures and all dimension members.

Example

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
    )

Dimension Member Condition

Sets the criteria for dimension members to be included in the build. Select the dimension first, and then select the criteria.

Template

Select {all members | none of the members | all members at the level(s) | members by condition} in dimension name.

Example 1

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)

Example 2

This template provides the basic syntax of a SQL WHERE clause on the dimension key column for you to edit.

Template: Select members by condition in dimension TIME.

Build Syntax: "TIME" WHERE "TIME".dim_key in ('1', '2')