1 package cwm$olap$level as
2
3
4 -- Set description for a level
5 --
6 -- param dimension_owner owner of the dimension
7 -- param dimension_name name of the dimension
8 -- param level_name name of the level
9 -- param description description text for the measure
10 --
11 -- raise no_access_privileges if no privileges to edit the dimension
12 -- raise dimension_not_found if the dimension does not exist in catalog
13 -- raise level_not_found if the level cannot be found within dimension
14 procedure set_description(dimension_owner varchar2
15 ,dimension_name varchar2
16 ,level_name varchar2
17 ,description varchar2);
18
19 -- Set display name for a level
20 --
21 -- param dimension_owner owner of the dimension
22 -- param dimension_name name of the dimension
23 -- param level_name name of the level
24 -- param display_name display name for the measure
25 --
26 -- raise no_access_privileges if no privileges to edit the dimension
27 -- raise dimension_not_found if the dimension does not exist in catalog
28 -- raise level_not_found if the level cannot be found within dimension
29 procedure set_display_name(dimension_owner varchar2
30 ,dimension_name varchar2
31 ,level_name varchar2
32 ,display_name varchar2);
33
34 -- Lock the level
35 --
36 -- param owner owner of the dimension
37 -- param dimension_name name of the dimension
38 -- param level_name name of level
39 -- param wait_for_lock wait for lock if acquired by other user
40 --
41 -- raise no_access_privileges if no privileges to edit the dimension
42 -- raise level_not_found if attribute doesn't exist
43 -- raise failed_to_gain_lock if lock could not be acquired
44 procedure lock_level(owner varchar2
45 , dimension_name varchar2
46 , level_name varchar2
47 , wait_for_lock boolean := false);
48
49
50 -- PRIVATE function to get internal id of the level
51 function get_level_id(owner varchar2
52 , dimension_name varchar2
53 , level_name varchar2) return number;
54
55 end;