Rem cwm2val.pls
Rem
Rem Copyright (c) 1900, 2002, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2val.pls 
Rem
Rem    DESCRIPTION
Rem      validate dimension and/or cube
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    awesley     01/28/03 - add Validate_All_Dimensions and Validate_Olap_Catalog
Rem    awesley     08/30/02 - added more validation
Rem    awesley     11/06/01 - awesley_txn100587
Rem    awesley     10/02/01 - Created
Rem


create or replace package cwm2_olap_validate as

  procedure Validate_Dimension(p_Dimension_Owner varchar2
                              ,p_Dimension_Name varchar2
                              ,p_Type_Of_Validation varchar2 default 'DEFAULT'
                              ,p_Verbose_Report varchar2     default 'YES'
                              );

  procedure Validate_Cube(p_Cube_Owner varchar2
                         ,p_Cube_Name varchar2
                         ,p_Type_Of_Validation varchar2 default 'DEFAULT'
                         ,p_Verbose_Report varchar2     default 'YES'
                         );

  procedure Validate_All_Dimensions(p_Type_Of_Validation varchar2 default 'DEFAULT'
                                   ,p_Verbose_Report varchar2     default 'YES'
                                   );

  procedure Validate_All_Cubes(p_Type_Of_Validation varchar2 default 'DEFAULT'
                              ,p_Verbose_Report varchar2     default 'YES'
                              );

  procedure Validate_Olap_Catalog(p_Type_Of_Validation varchar2 default 'DEFAULT'
                                 ,p_Verbose_Report varchar2     default 'YES'
                                 );

end cwm2_olap_validate;
/

show errors;