Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
CWM2_OLAP_AW_ACCESS , 9 of 9
This procedure creates a SQL script that will create the relational objects needed for SQL to access objects in the analytic workspace, such as object types and views. It takes a delimited string as input for the mapping information.
CreateAWAccessStructures( script_directory VARCHAR2, script_filename VARCHAR2, prefix VARCHAR2, aw_name VARCHAR2, mapping_info VARCHAR2);
Parameter | Description |
---|---|
|
An existing directory path where |
|
The file name that will be given to the generated SQL script. This procedure does not overwrite an existing file, so be sure that a file by the name you specify does not already exist in |
|
A prefix that will be given to the view created by executing the script. This prefix identifies the objects in a schema that relate to the analytic workspace. It can be up to 25 characters long, and must comply with the requirements for a database object name. |
|
The name of the analytic workspace where the source objects are stored. |
|
A delimited string that contains mapping information, as described in "Specifying the Source and Target Objects". |
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|