Skip Headers
Oracle® OLAP DML Reference
10g Release 2 (10.2)

Part Number B14346-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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) Set the POUTFILEUNIT option so that you can monitor the progress of the allocation.

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

  6. (Optional) Set the $ALLOCMAP 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.

For brief descriptions of all of the OLAP DML statements that relate to allocation, see "Allocation Statements".