Oracle DBMS_CUBE_UTIL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Question: Has GET_DIMENSION_SPECIAL_MEMBER from 12.1.0.2 been dropped? Check GA release when available.
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 DBMS_OUTPUT
ALL_CUBE_HIERARCHIES DBMS_CUBE_UTIL_DFLT_MSR_T DBMS_STANDARD
DBMS_ASSERT DBMS_CUBE_UTIL_EXT_MD_R DBMS_UTILITY
DBMS_AW DBMS_CUBE_UTIL_EXT_MD_T PLITBLM
DBMS_AW_LIB 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
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

Related Topics
DBMS_CUBE
DBMS_CUBE_ADVISE_SEC
DBMS_CUBE_LOG
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved