| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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 |
| 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');
PL/SQL procedure successfully completed. |
| |
| 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 |