1 package cwm$olap$level$attribute as
2
3 -- Set the name of a level attribute
4 --
5 -- param owner dimension owner
6 -- param dimension_name name of dimension containing level
7 -- param level_name name of level defining attribute
8 -- param attribute_column column of level attribute
9 -- param attribute_name name to set for the level attribute
10 --
11 -- raise no_access_privileges if no privileges to edit the dimension
12 -- raise attribute_not_found if attribute doesn't exist
13 -- raise invalid_name if name is not valid
14 procedure set_name(owner varchar2
15 , dimension_name varchar2
16 , level_name varchar2
17 , attribute_column varchar2
18 , attribute_name varchar2);
19
20 -- Set description text for a level attribute
21 --
22 -- param owner dimension owner
23 -- param dimension_name name of dimension containing level
24 -- param level_name name of level defining attribute
25 -- param attribute_name name of level attribute
26 -- param description the description text to be set
27 --
28 -- raise no_access_privileges if no privileges to edit the dimension
29 -- raise attribute_not_found if attribute doesn't exist
30 procedure set_description(owner varchar2
31 , dimension_name varchar2
32 , level_name varchar2
33 , attribute_name varchar2
34 , description varchar2);
35
36 -- Set the display name for a level attribute
37 --
38 -- param owner dimension owner
39 -- param dimension_name name of dimension containing level
40 -- param level_name name of level defining attribute
41 -- param attribute_name name of level attribute
42 -- param display_name the display name for the attribute
43 --
44 -- raise no_access_privileges if no privileges to edit the dimension
45 -- raise attribute_not_found if attribute doesn't exist
46 procedure set_display_name(owner varchar2
47 , dimension_name varchar2
48 , level_name varchar2
49 , attribute_name varchar2
50 , display_name varchar2);
51
52 -- Lock the level attribute
53 --
54 -- param owner owner of the dimension
55 -- param dimension_name name of the dimension
56 -- param level_name name of level defining attribute
57 -- param attribute_name name of level attribute
58 -- param wait_for_lock wait for lock if acquired by other user
59 --
60 -- raise no_access_privileges if no privileges to edit the dimension
61 -- raise attribute_not_found if attribute doesn't exist
62 -- raise failed_to_gain_lock if lock could not be acquired
63 procedure lock_attribute(owner varchar2
64 , dimension_name varchar2
65 , level_name varchar2
66 , attribute_name varchar2
67 , wait_for_lock boolean := false);
68
69
70 -- PRIVATE function to get internal id of the level attribute
71 function get_attribute_id(owner varchar2
72 , dimension_name varchar2
73 , level_name varchar2
74 , attribute_name varchar2) return number;
75 end;