CWM2_OLAP_AW_ACCESS , 9 of 10

CreateAWAccessStructures_FR 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. As input, it takes a text file that maps the workspace objects to columns of the views.

Syntax

CreateAWAccessStructures_FR(
   script_directory      VARCHAR2,
   script_name           VARCHAR2,
   prefix                VARCHAR2,
   aw_name               VARCHAR2,
   infile_directory      VARCHAR2
   infile_name           VARCHAR2);

Parameters

Table 15-6 CreateAWAccessStructures_FR 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.
`infile_directory`	The directory path where the `infile_name` is stored.
`infile_name`	The name of the input file that contains mapping information, as described in Example , "Specifying the Source and Target Objects".