Previous
Previous
 
Next
Next

Allocating Data

To allocate data using an aggmap object, use the following OLAP DML statements in the order indicated:

  1. Issue a DEFINE AGGMAP statement to define the aggmap object.


    Note:

    When using the OLAP Worksheet, at the command line level, immediately after the DEFINE AGGMAP statement, enter an "empty" allocation specification by coding an ALLOCMAP statement. For example:
    DEFINE myaggmap AGGMAP
    ALLOCMAP 'END'
    

  2. Add a specification to the aggmap object that specifies the allocation that you want performed. See ALLOCMAP for more information.

  3. When you want the aggmap object to be a permanent part of the analytic workspace, save the aggmap object using an UPDATE statement followed by COMMIT.

  4. (Optional) Use the DBMS_CUBE_LOG.ENABLE procedure to log the allocation operation.

  5. (Optional) Redesign the allocation error log by setting the ALLOCERRLOGFORMAT and ALLOCERRLOGHEADER options to nondefault values.

  6. (Optional) Set the $ALLOCMAP property on one or more variables to specify that the aggmap is the default allocation specification for the variables.

  7. (Recommended, but optional) Limit the variable to the target cells (that is, the cells into which you want to allocate data).

  8. Issue an ALLOCATE statement to allocate the data.