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

cwm2_olap_hierarchy

cwm2_olap_hierarchy defines hierarchical relationships for dimension levels within an OLAP catalog

Functions/Procedures

create_hierarchy

create_hierarchy (
          dimension_owner    in varchar2,
          dimension_name     in varchar2,
          hierarchy_name     in varchar2,
          display_name       in varchar2,
          short_description  in varchar2,
          description        in varchar2,
          solved_code        in varchar2);
solved_code can assume one of the following values:
  • UNSOLVED LEVEL-BASED
  • SOLVED LEVEL-BASED
  • SOLVED VALUE-BASED

drop_hierarchy