CWM2_OLAP_AW_ACCESS , 10 of 10

CreateAWAccessStructures Procedure

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.

Syntax

CreateAWAccessStructures(
   script_directory      VARCHAR2,
   script_filename       VARCHAR2,
   prefix                VARCHAR2,
   aw_name               VARCHAR2,
   mapping_info          VARCHAR2);

Parameters

Table 15-7 CreateAWAccessStructures Procedure Parameters

Parameter	Description
`script_directory`	An existing directory path where `script_name` will be written.
`script_name`	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 `script_directory`.
`prefix`	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.
`aw_name`	The name of the analytic workspace where the source objects are stored.
`mapping_info`	A delimited string that contains mapping information, as described in "Specifying the Source and Target Objects".