Prerequisites

The utl_file_dir parameter must be set to a valid directory, as described in "Initialization Parameters for Oracle OLAP". Otherwise, the procedures in CWM2_OLAP_AW_ACCESS will not be able to write the SQL scripts to a file.