Rem
Rem cwm2cube.pls
Rem
Rem Copyright (c) 1900, 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2cube.pls - <one-line expansion of the name>
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    09/25/03 - 
Rem    dbardwel    04/09/03 - Adding API call to set agg operator
Rem    awesley     11/06/01 - awesley_txn100587
Rem    awesley     09/11/01 - Created
Rem

create or replace package cwm2_olap_cube as

  procedure Create_Cube(p_Cube_Owner varchar2
                       ,p_Cube_Name varchar2
                       ,p_Display_Name varchar2
                       ,p_Short_Description varchar2
                       ,p_Description varchar2);

  procedure Set_Cube_Name(p_Cube_Owner varchar2
                         ,p_Cube_Name varchar2
                         ,p_Set_Cube_Name varchar2);

  procedure Set_Display_Name(p_Cube_Owner varchar2
                            ,p_Cube_Name varchar2
                            ,p_Display_Name varchar2);

  procedure Set_Short_Description(p_Cube_Owner varchar2
                                 ,p_Cube_Name varchar2
                                 ,p_Short_Description varchar2);

  procedure Set_Description(p_Cube_Owner varchar2
                           ,p_Cube_Name varchar2
                           ,p_Description varchar2);

  procedure Set_MV_Summary_Code(p_Cube_Owner varchar2
                               ,p_Cube_Name varchar2
                               ,p_Summary_Code varchar2);

  procedure Drop_Cube(p_Cube_Owner varchar2
                     ,p_Cube_Name varchar2
                     ,p_Silent varchar2 default null);

  procedure Lock_Cube(p_Cube_Owner varchar2
                     ,p_Cube_Name varchar2
                     ,p_Wait_For_Lock boolean default false);

  procedure Add_Dimension_To_Cube(p_Cube_Owner varchar2
                                 ,p_Cube_Name varchar2
                                 ,p_Dimension_Owner varchar2
                                 ,p_Dimension_Name varchar2);

  procedure Set_Default_Cube_Dim_Calc_Hier(p_Cube_Owner varchar2
                                          ,p_Cube_Name varchar2
                                          ,p_Dimension_Owner varchar2
                                          ,p_Dimension_Name varchar2
                                          ,p_hierarchy_name varchar2);

  procedure Set_Aggregation_Operator(p_Cube_Owner varchar2
                                     ,p_Cube_Name varchar2
                                     ,p_AggOper_Spec varchar2);


  procedure Remove_Dimension_From_Cube(p_Cube_Owner varchar2
                                      ,p_Cube_Name varchar2
                                      ,p_Dimension_Owner varchar2
                                      ,p_Dimension_Name varchar2);

end cwm2_olap_cube;
/

show errors;