Oracle | DBMS_CUBE

Oracle DBMS_CUBE_UTIL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented

AUTHID CURRENT_USER

Data Types CREATE TYPE dbms_cube_util_dflt_msr_r AS OBJECT ( owner VARCHAR2(128), cube_name VARCHAR2(128), default_measure VARCHAR2(128) ); CREAT TYPE dbms_cube_util_dflt_msr_t AS TABLE OF dbms_cube_util_dflt_msr_r; CREATE TYPE dbms_cube_util_ext_md_r AS OBJECT ( owner VARCHAR2(128), dimension_name VARCHAR2(128), hierarchy_name VARCHAR2(128), default_member VARCHAR2(4000), depth_count NUMBER, depth NUMBER, depth_cardinality NUMBER); CREATE TYPE dbms_cube_util_ext_md_t AS TABLE OF dbms_cube_util_ext_md_r;

Dependencies

ALL_CUBE_DIMENSIONS	DBMS_CUBE_UTIL_DFLT_MSR_T	DBMS_OUTPUT
DBMS_ASSERT	DBMS_CUBE_UTIL_EXT_MD_R	DBMS_STANDARD
DBMS_AW_LIB	DBMS_CUBE_UTIL_EXT_MD_T	PLITBLM
DBMS_CUBE	DBMS_LOB

Documented No

Exceptions

Error Code	Reason
ORA-20405	Dimension SYS.CUSTOMERS_DIM does not exist.

First Available 12.2.0.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/olap/admin/dbmscbu.sql

Subprograms

CREATE_RPT_FILTER	DROP_RPT_FILTER	GET_EXT_METADATA
DROP_BRANCH	GET_DEFAULT_MEASURE

CREATE_RPT_FILTER

Undocumented

Overload 1 dbms_cube_util.create_rpt_filter( p_owner IN VARCHAR2, p_dimension IN VARCHAR2, p_rfname IN VARCHAR2, p_member_list IN VARCHAR2);

TBD

Overload 2 dbms_cube_util.create_rpt_filter( p_dimension IN VARCHAR2, p_rfname IN VARCHAR2, p_member_list IN CLOB);

TBD

DROP_BRANCH

Undocumented dbms_cube_util.drop_branch( p_owner IN VARCHAR2, p_dimension IN VARCHAR2);

exec dbms_cube_util.drop_branch(USER, 'CUSTOMERS_DIM');

DROP_RPT_FILTER

Undocumented dbms_cube_util.drop_rpt_filter( p_owner IN VARCHAR2, p_dimension IN VARCHAR2, p_rfname IN VARCHAR2);

TBD

GET_DEFAULT_MEASURE

Returns default measure dbms_cube_util.get_default_measure( owner IN VARCHAR2, cube_name IN VARCHAR2) RETURN sys.dbms_cube_util.dflt_msr_t;

TBD

GET_EXT_METADATA

Returns extended metadata dbms_cube_util.get_ext_metadata( owner IN VARCHAR2, dimension_name IN VARCHAR2) RETURN sys.dbms_cube_util_ext_md_t;

TBD