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

cwm2_olap_level

cwm2_olap_level creates levels and assigns them to hierarchies within an OLAP catalog

Functions/Procedures

create_level

create_level (
  dimension_owner    in varchar2,
  dimension_name     in varchar2,
  level_name         in varchar2,
  display_name       in varchar2,
  plural_name        in varchar2,
  short_description  in varchar2,
  description        in varchar2);

add_level_to_hierarchy

add_level_to_hierarchy (
  dimension_owner   in varchar2,
  dimension_name    in varchar2,
  hierarchy_name    in varchar2,
  level_name        in varchar2,
  parent_level_name in varchar2  default null);
A dimension can have n hierarchies associated with it and it can also have n levels associated with it. add_level_to_hierarchy is the means to specify the different levels in a hierarchy.