Oracle DBMS_CUBE_UTIL
Version 18.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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_LOB
ALL_CUBE_HIERARCHIES DBMS_CUBE_UTIL_DFLT_MSR_T DBMS_OUTPUT
DBMS_ASSERT DBMS_CUBE_UTIL_EXT_MD_R DBMS_STANDARD
DBMS_AW DBMS_CUBE_UTIL_EXT_MD_T PLITBLM
DBMS_AW_LIB    
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
Built-in Functions
Built-in Packages
DBMS_CUBE
DBMS_CUBE_ADVISE_SEC
DBMS_CUBE_LOG
What's New In 18c
What's New In 19c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx