René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
cwm2_olap_level | ||
cwm2_olap_level creates levels and assigns them to hierarchies within an
OLAP catalog
Functions/Procedurescreate_levelcreate_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_hierarchyadd_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.
|