René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

cwm2_olap_dimension

cwm2_olap_dimension manages dimensions within an OLAP catalog.

Functions/Procedures

create_dimension

create_dimension (
  dimension_owner    in varchar2,
  dimension_name     in varchar2,
  display_name       in varchar2,
  plural_name        in varchar2,
  short_description  in varchar2,
  description        in varchar2,
  dimension_type     in varchar2 default null);
dimension_type can either be null or 'time'.

drop_dimension

set_default_display_hierarchy

set_default_display_hierarchy  (
  dimension_owner in varchar2,
  dimension_name  in varchar2,
  hierarchy_name  in varchar2);