Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
CWM2_OLAP_PC_TRANSFORM , 3 of 3
This procedure generates a script that converts a parent/child dimension table to an embedded-total dimension table.
CREATE_SCRIPT ( directory IN VARCHAR2, schema IN VARCHAR2, pc_table IN VARCHAR2, pc_parent IN VARCHAR2, pc_child IN VARCHAR2, t_table IN VARCHAR2, t_tablespace IN VARCHAR2, pc_root IN VARCHAR2 DEFAULT, levels IN VARCHAR2 DEFAULT, levels_list IN VARCHAR2 DEFAULT, short_description IN VARCHAR2 DEFAULT, long_description IN VARCHAR2 DEFAULT, attributes_list IN VARCHAR2 DEFAULT);
CREATE_SCRIPT
procedure must have write access to the directory where the script will reside. The database must be able to execute scripts in this directory.null
in the pc_parent
parameter. If the root is identified some other way, you may need to edit the generated script and change the way that the root is identified.et_levels
parameter.
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|