Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-03 |
|
|
PDF · Mobi · ePub |
To allocate data using an aggmap object, use the following OLAP DML statements in the order indicated:
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'
Add a specification to the aggmap object that specifies the allocation that you want performed. See ALLOCMAP for more information.
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.
(Optional) Set the POUTFILEUNIT option so that you can monitor the progress of the allocation.
(Optional) Redesign the allocation error log by setting the ALLOCERRLOGFORMAT and ALLOCERRLOGHEADER options to nondefault values.
(Optional) Set the $ALLOCMAP on one or more variables to specify that the aggmap is the default allocation specification for the variables.
(Recommended, but optional) Limit the variable to the target cells (that is, the cells into which you want to allocate data).
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".