René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
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/Proceduresmap_dimtbl_hierlevelmap_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_hierlevelattrprocedure 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_levelkeyprocedure 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_measureprocedure 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 ); |