1 PACKAGE dbms_cube_util AUTHID CURRENT_USER AS
2
3 ---------------------
4 -- OVERVIEW
5 --
6 -- This package is the interface to cube utility functions
7 --
8 ---------------------
9 -- Visibility
10 -- All users
11 --
12
13 ---------------------
14 -- CONSTANTS
15
16 ---------------------
17 -- EXCEPTIONS
18
19 ---------------------
20 -- PROCEDURES
21
22 -- Create a report filter
23 PROCEDURE create_rpt_filter(p_owner IN VARCHAR2,
24 p_dimension IN VARCHAR2,
25 p_rfname IN VARCHAR2,
26 p_member_list IN VARCHAR2);
27
28 PROCEDURE create_rpt_filter(p_owner IN VARCHAR2,
29 p_dimension IN VARCHAR2,
30 p_rfname IN VARCHAR2,
31 p_member_list IN CLOB);
32
33 -- Drop a report filter
34 PROCEDURE drop_rpt_filter(p_owner IN VARCHAR2,
35 p_dimension IN VARCHAR2,
36 p_rfname IN VARCHAR2);
37
38 -- Drop a branch
39 PROCEDURE drop_branch(p_owner IN VARCHAR2,
40 p_dimension IN VARCHAR2);
41
42 -- Get HIERARCHY ALL or DEFAULT member for a cube dimension hierarchy
43 -- Valid specialMemberTypes:
44 -- HIERARCHY_ALL, DEFAULT_FIRST, DEFAULT_LAST or DEFAULT
45 -- DEFAULT and DEFAULT_LAST are the same.
46 -- When a hierarchy name is not specified the dimension is treated
47 -- as a LIST dimension for the purpose of getting a DEFAULT member.
48 FUNCTION get_dimension_special_member
49 (qualifiedHierarchy IN VARCHAR2, -- "OWNER"."DIMENSION"[."HIERARCHY"]
50 specialMemberType IN VARCHAR2 DEFAULT 'DEFAULT')
51 RETURN VARCHAR2;
52
53 -- return extended metadata
54 FUNCTION get_ext_metadata(owner IN VARCHAR2 DEFAULT NULL,
55 dimension_name IN VARCHAR2 DEFAULT NULL)
56 return sys.dbms_cube_util_ext_md_t
57 pipelined;
58
59 -- return default measure
60 FUNCTION get_default_measure(owner IN VARCHAR2 DEFAULT NULL,
61 cube_name IN VARCHAR2 DEFAULT NULL)
62 return sys.dbms_cube_util_dflt_msr_t
63 pipelined;
64
65 END dbms_cube_UTIL;