Rem
Rem $Header: cwmlite/admin/cwm2mrat.sql /main/2 2009/01/12 16:49:19 dbardwel Exp $
Rem
Rem cwm2mrat.sql
Rem
Rem Copyright (c) 2002, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      cwm2mrat.sql - script for metadata reader tables for performance
Rem                     enhancements 
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    dbardwel    01/12/09 - Make AW_PROP_VALUE column varchar2(4000).
Rem    dbardwel    06/25/03 - dbardwel_txn107256
Rem    dbardwel    05/23/03 - 
Rem    mstasiew    04/15/03 - 
Rem    mstasiew    04/14/03 - mstasiew_txn106951
Rem    mstasiew    04/14/03 - Created
Rem


create table olapsys.MRAC_OLAP2_AWS_T (
 OWNER                                     VARCHAR2(30) not null,
 AW                                                 VARCHAR2(30)
)
/

create table olapsys.MRAC_OLAP2_AW_MAP_DIM_USE_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_OBJECT_NAME                                     VARCHAR2(90),
 DIMENSION_OWNER                                    VARCHAR2(1000),
 DIMENSION_NAME                                     VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_PHYS_OBJ_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_OBJECT_NAME                                     VARCHAR2(90),
 AW_OBJECT_TYPE                                     VARCHAR2(1000),
 AW_OBJECT_DATATYPE                                 VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_PHYS_OBJ_PROP_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_OBJECT_NAME                                     VARCHAR2(90),
 AW_PROP_NAME                                       VARCHAR2(1000),
 AW_PROP_VALUE                                      VARCHAR2(4000)
)
/

create table olapsys.MRAC_OLAP2_AW_MAP_MEAS_USE_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_OBJECT_NAME                                     VARCHAR2(90),
 CUBE_OWNER                                         VARCHAR2(1000),
 CUBE_NAME                                          VARCHAR2(1000),
 MEASURE_NAME                                       VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_MAP_ATTR_USE_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_OBJECT_NAME                                     VARCHAR2(90),
 DIMENSION_OWNER                                    VARCHAR2(1000),
 DIMENSION_NAME                                     VARCHAR2(1000),
 ATTRIBUTE_NAME                                     VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_DIMENSIONS_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_LOGICAL_NAME                                    VARCHAR2(90),
 AW_PHYSICAL_OBJECT                                 VARCHAR2(1000),
 SOURCE_OWNER                                       VARCHAR2(1000),
 SOURCE_NAME                                        VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_ATTRIBUTES_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_DIMENSION_NAME                                  VARCHAR2(1000),
 AW_LOGICAL_NAME                                    VARCHAR2(90),
 AW_PHYSICAL_OBJECT                                 VARCHAR2(1000),
 DISPLAY_NAME                                       VARCHAR2(1000),
 DESCRIPTION                                        VARCHAR2(1000),
 ATTRIBUTE_TYPE                                     VARCHAR2(1000),
 SOURCE_OWNER                                       VARCHAR2(1000),
 SOURCE_DIMENSION_NAME                              VARCHAR2(1000),
 SOURCE_NAME                                        VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_CUBES_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_LOGICAL_NAME                                    VARCHAR2(90),
 AW_PHYSICAL_OBJECT                                 VARCHAR2(1000),
 SOURCE_OWNER                                       VARCHAR2(1000),
 SOURCE_NAME                                        VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_CUBE_DIM_USES_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_LOGICAL_NAME                                    VARCHAR2(90),
 DIMENSION_AW_OWNER                                 VARCHAR2(1000),
 DIMENSION_AW_NAME                                  VARCHAR2(1000),
 DIMENSION_SOURCE_OWNER                             VARCHAR2(1000),
 DIMENSION_SOURCE_NAME                              VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_DIM_LEVELS_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_LOGICAL_NAME                                    VARCHAR2(90),
 LEVEL_NAME                                         VARCHAR2(1000),
 DISPLAY_NAME                                       VARCHAR2(1000),
 DESCRIPTION                                        VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_CUBE_MEASURES_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_CUBE_NAME                                       VARCHAR2(90),
 AW_MEASURE_NAME                                    VARCHAR2(1000),
 AW_PHYSICAL_OBJECT                                 VARCHAR2(1000),
 MEASURE_SOURCE_NAME                                VARCHAR2(1000),
 DISPLAY_NAME                                       VARCHAR2(1000),
 DESCRIPTION                                        VARCHAR2(1000),
 IS_AGGREGATEABLE                                   VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_CUBE_AGG_SPECS_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_CUBE_NAME                                       VARCHAR2(90),
 AW_AGGSPEC_NAME                                    VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_CUBE_AGG_MEAS_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_CUBE_NAME                                       VARCHAR2(90),
 AW_AGGSPEC_NAME                                    VARCHAR2(1000),
 AW_MEASURE_NAME                                    VARCHAR2(1000)
)
/

create table olapsys.MRAC_OLAP2_AW_CUBE_AGG_LVL_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_CUBE_NAME                                       VARCHAR2(90),
 AW_AGGSPEC_NAME                                    VARCHAR2(1000),
 AW_DIMENSION_NAME                                  VARCHAR2(1000),
 AW_LEVEL_NAME                                      VARCHAR2(1000)
)
/
create table olapsys.MRAC_OLAP2_AW_CUBE_AGG_OP_T (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_CUBE_NAME                                       VARCHAR2(90),
 AW_AGGSPEC_NAME                                    VARCHAR2(1000),
 AW_DIMENSION_NAME                                  VARCHAR2(1000),
 OPERATOR                                           VARCHAR2(1000)
)
/

create table olapsys.MRAC_olap2_aw_hier_lvl_ord_t (
 AW_OWNER                                           VARCHAR2(30),
 AW_NAME                                            VARCHAR2(30),
 AW_DIMENSION_NAME                                  VARCHAR2(90),
 AW_HIERARCHY_NAME                                  VARCHAR2(1000),
 IS_DEFAULT_HIER                                    VARCHAR2(1000),
 AW_LEVEL_NAME                                      VARCHAR2(1000),
 POSITION                                           NUMBER
)
/