1 package cwm$olap$dimension as
2
3 -- Set a plural name for a dimension.
4 --
5 -- param owner owner of the dimension
6 -- param dimension_name name of the dimension
7 -- param plural_name new plural name for the dimension
8 --
9 -- raise no_access_privileges if no privileges to edit the dimension
10 -- raise dimension_not_found if dimension doesn't exist
11 procedure set_plural_name(owner varchar2
12 , dimension_name varchar2
13 , plural_name varchar2);
14
15 -- Set a display name for a dimension.
16 --
17 -- param owner owner of the dimension
18 -- param dimension_name name of the dimension
19 -- param display_name new display name for the dimension
20 --
21 -- raise no_access_privileges if no privileges to edit the dimension
22 -- raise dimension_not_found if dimension doesn't exist
23 procedure set_display_name(owner varchar2
24 , dimension_name varchar2
25 , display_name varchar2);
26
27 -- Set the description for a dimension.
28 --
29 -- param owner owner of the dimension
30 -- param dimension_name name of the dimension
31 -- param description new descriptive text for the dimension
32 --
33 -- raise no_access_privileges if no privileges to edit the dimension
34 -- raise dimension_not_found if dimension doesn't exist
35 procedure set_description(owner varchar2
36 , dimension_name varchar2
37 , description varchar2);
38
39 -- Set a new default display hierarcy for the dimension
40 --
41 -- param owner owner of the dimension
42 -- param dimension_name name of the dimension
43 -- param hierarchy_name name of the default display hierarchy
44 --
45 -- raise no_access_privileges if no privileges to edit the dimension
46 -- raise dimension_not_found if dimension doesn't exist
47 procedure set_default_display_hierarchy(owner varchar2
48 ,dimension_name varchar2
49 ,hierarchy_name varchar2);
50
51 -- Lock the dimension metadata for update
52 --
53 -- param owner owner of the dimension
54 -- param dimension_name name of the dimension
55 -- param wait_for_lock wait for lock if acquired by other user
56 --
57 -- raise no_access_privileges if no privileges to edit the dimension
58 -- raise dimension_not_found if dimension does not exist
59 -- raise failed_to_gain_lock if lock could not be acquired
60 procedure lock_dimension(owner varchar2
61 , dimension_name varchar2
62 , wait_for_lock boolean := false);
63
64 -- Internal function to get the id of a dimension, creating a CWM
65 -- dimension instance if it doesn't already exist.
66 --
67 -- param owner owner of the dimension
68 -- param dimension_name name of the dimension
69 --
70 -- raise dimension_not_found if dimension doesn't exist
71 function get_dimension_id(owner varchar2
74 end;72 , dimension_name varchar2) return number;
73