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

cwm2_olap_table_map

cwm2_olap_table_map maps dimension levels and level attributes to columns in dimension tables.
The dimension level and level attributes are defined within an OLAP catalog

Functions/Procedures

map_dimtbl_hierlevel

map_dimtbl_hierlevel (
   dimension_owner in varchar2,
   dimension_name  in varchar2,
   hierarchy_name  in varchar2,
   level_name      in varchar2,
   table_owner     in varchar2,
   table_name      in varchar2,
   keycol          in varchar2,
   parentcol       in varchar2 default null);

map_dimtbl_hierlevelattr

procedure map_dimtbl_hierlevelattr (
  p_dimension_owner           in varchar2,
  p_dimension_name            in varchar2,
  p_dimension_attribute_name  in varchar2,
  p_hierarchy_name            in varchar2,
  p_level_name                in varchar2,
  p_level_attribute_name      in varchar2,
  p_table_owner               in varchar2,
  p_table_name                in varchar2,
  p_attrcol                   in varchar2
)

map_facttbl_levelkey

procedure map_facttbl_levelkey (
  p_cube_owner       in  varchar2,
  p_cube_name        in  varchar2,
  p_facttable_owner  in  varchar2,
  p_facttable_name   in  varchar2,
  p_storetype        in  varchar2,
  p_dimkeymap        in  varchar2,
  p_dimktype         in  varchar2 default null
);

map_facttbl_measure

procedure map_facttbl_measure (
  p_cube_owner       in  varchar2,
  p_cube_name        in  varchar2,
  p_measure_name     in  varchar2,
  p_facttable_owner  in  varchar2,
  p_facttable_name   in  varchar2,
  p_column_name      in  varchar2,
  p_dimkeymap        in  varchar2
);