Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The following table describes the subprograms provided in DBMS_AW
.
Subprogram | Description |
---|---|
Populates a table type named |
|
Suggests how to preaggregate a cube, based on a specified percentage of the cube's data. |
|
Returns a recommended composite definition for the cube and a recommended dimension order. |
|
Generates the OLAP DML commands for defining the recommended composite and measures in a cube. |
|
Identifies the dimension that the Sparsity Advisor partitioned over. |
|
Returns the level used by the Sparsity Advisor for partitioning over a dimension. |
|
Suggests how to preaggregate a dimension, based on a specified percentage of the dimension's members. |
|
Analyzes a fact table for sparsity and populates a table with the results of its analysis. |
|
Attaches an analytic workspace to a session. |
|
Creates a new analytic workspace and populates it with the object definitions and data from another analytic workspace. |
|
Creates a new, empty analytic workspace. |
|
Deletes an analytic workspace |
|
Detaches an analytic workspace from a session. |
|
Changes the name of an analytic workspace. |
|
Returns the name of the tablespace in which a particular analytic workspace is stored. |
|
Saves changes made to an analytic workspace. |
|
Converts an analytic workspace from 9i to 10g storage format. |
|
Returns the result of a numeric expression in an analytic workspace. |
|
Returns the result of a text expression in an analytic workspace. |
|
Executes one or more OLAP DML commands. Input and output is limited to 4K. Typically used in an interactive session using an analytic workspace. |
|
Returns the session log from the last execution of the |
|
Executes the OLAP DML commands specified in a file. |
|
Executes one or more OLAP DML commands. Input is limited to 4K and output to 4G. Typically used in applications when the 4K limit on output for the |
|
Executes one or more OLAP DML commands. Input and output are limited to 4G. Typically used in applications when the 4K input limit of the |
|
Executes one or more OLAP DML commands and suppresses the output. Input is limited to 4K and output to 4G. |
|
Returns a boolean indicating whether or not the OLAP option is installed in the database. |
|
Returns a boolean indicating whether or not the OLAP option has been initialized in the current session. |
|
Prints a session log returned by the |
|
Executes one or more OLAP DML commands. |
|
Shuts down the current OLAP session. |
|
Creates a table which the |
|
Starts an OLAP session without attaching a user-defined analytic workspace. |