[Home] [Help]
PACKAGE: OLAPSYS.CWM2_OLAP_UTILITY
Source
1 package cwm2_olap_utility as
2
3 -- SEE Debug_On/OFF
4 DEBUG_OFF constant boolean := false;
5 DEBUG_ON constant boolean := true;
6 -- debug switches could be defined in an array but that will serverly affect runtime
7 -- 1 2 3
8 --123456789012345678901234567890 boolean := DEBUG_OFF
9 DEBUG_CWM1VALM_TRACE boolean := DEBUG_OFF;
10 DEBUG_CWM2VALM_TRACE boolean := DEBUG_OFF;
11 DEBUG_CWM2VALU_SELECT boolean := DEBUG_OFF;
12 DEBUG_CWM2EXP_TRACE boolean := DEBUG_OFF;
13
14
15 -- SEE function Get_Access_Rights
16 ACCESS_RIGHTS_NONE constant varchar2(30) := 'NONE';
17 ACCESS_RIGHTS_PRIVILEGE constant varchar2(30) := 'PRIVILEGE';
18 ACCESS_RIGHTS_OWNER constant varchar2(30) := 'OWNER';
19 ACCESS_RIGHTS_DBA constant varchar2(30) := 'DBA';
20
21 --FactDimHierTplsDtl
22 type t_DH_Record is record
23 (v_Dimension number
24 ,v_Dimension_IRID number
25 ,v_Dimension_Name varchar2(30)
26 ,v_Hierarchy number
27 ,v_Hierarchy_IRID number
28 ,v_Hierarchy_Name varchar2(30)
29 );
30 type t_DH_Table is table of t_DH_Record;
31 v_DH t_DH_Table := t_DH_Table();
32
33 --Object ID
34 procedure Get_Object_ID(p_Source_Owner IN varchar2
35 ,p_Source_Name IN varchar2
36 ,p_Source_Id OUT number
37 ,p_Source_Type OUT number
38 ,p_Object_Owner OUT varchar2
39 ,p_Object_Name OUT varchar2
40 ,p_Object_Id OUT number
41 ,p_Object_Type OUT number
42 );
43
44 --Access rights
45 function Get_Access_Rights(p_Model varchar2 -- 'CWM1' or 'CWM2'
46 ,p_Entity_Type varchar2 -- 'DIMENSION' or 'CUBE'
47 ,p_Entity_Owner varchar2
48 ,p_Entity_Name varchar2
49 ,p_Entity_IRID number
50 ) return varchar2;
51
52 procedure Drop_Val_FactDimHierTplsDtl(p_Cube IN OLAPSYS.CwM2$Cube%rowtype
53 ,p_Entity_Name IN OUT OLAPSYS.CwM2$OLAPValidateTable%rowtype
54 ,p_Count IN OUT number
55 ,p_Invalid IN OUT number
56 ,p_Comment IN OUT varchar2
57 ,p_Command IN varchar2 default 'VALIDATE'
58 ,p_Dimension_IRID IN number default null
59 ,p_Dimension_Number IN number default 1
60 ,p_DH IN t_DH_Table default null
61 ,p_Select IN varchar2 default null
62 ,p_From IN varchar2 default null
63 ,p_Where IN varchar2 default null
64 ,p_Message IN varchar2 default null
65 );
66
67 --Table
68 function Get_Table_Name(p_Table_ID number)
69 return varchar2;
70
71 --User
72 function Get_User_Name return varchar2;
73
74
75 --Measure
76 function Get_Measure_Name(p_Measure_IRID number
77 ,p_Log_Exception boolean default true)
78 return varchar2;
79
80 function Get_Measure_IRID(p_Cube_IRID number
81 ,p_Measure_Name varchar2
82 ,p_Log_Exception boolean default true
83 ,p_For_Update boolean default false
84 ,p_Wait_For_Lock boolean default false)
85 return number;
86
87 procedure Drop_Measure(p_Measure_IRID number);
88
89 procedure Drop_Measure_C_IRID(p_Cube_IRID number);
90
91 --HierLevelRel
92 function Get_HierLevelRel_C_Name(p_HierLevelRel_IRID number
93 ,p_Log_Exception boolean default true)
94 return varchar2;
95
96 function Get_HierLevelRel_P_Name(p_HierLevelRel_IRID number
97 ,p_Log_Exception boolean default true)
98 return varchar2;
99
100 function Get_HierLevelRel_IRID_C_IRID(p_Dimension_IRID number
101 ,p_Hierarchy_IRID number
102 ,p_Child_Level_IRID number
103 ,p_Log_Exception boolean default true)
104 return number;
105
106 function Get_HierLevelRel_IRID_P_IRID(p_Dimension_IRID number
107 ,p_Hierarchy_IRID number
108 ,p_Parent_Level_IRID number
109 ,p_Log_Exception boolean default true)
110 return number;
111
112 procedure Drop_HierLevelRel(p_HierLevelRel_IRID number);
113
114 procedure Drop_HierLevelRel_D_IRID(p_Dimension_IRID number);
115
116 procedure Drop_HierLevelRel_H_IRID(p_Hierarchy_IRID number);
117
118 procedure Drop_HierLevelRel_L_IRID(p_Level_IRID number);
119
120
121 --LevelAttribute
122 function Get_LevelAttribute_Name(p_LevelAttribute_IRID number
123 ,p_Log_Exception boolean default true)
124 return varchar2;
125
126 function Get_LevelAttribute_IRID(p_Dimension_IRID number
127 ,P_DimensionAttribute_IRID number
128 ,P_Level_IRID number
129 ,p_LevelAttribute_Name varchar2
130 ,p_Log_Exception boolean default true
131 ,p_For_Update boolean default false
132 ,p_Wait_For_Lock boolean default false)
133 return number;
134
135 procedure Drop_LevelAttribute(p_LevelAttribute_IRID number);
136
137 procedure Drop_LevelAttribute_D_IRID(p_Dimension_IRID number);
138
139 procedure Drop_LevelAttribute_L_IRID(p_Level_IRID number);
140
144 --Level
141 procedure Drop_LevelAttribute_DA_IRID(p_DimensionAttribute_IRID number);
142
143
145 function Get_Level_Name(p_Level_IRID number
146 ,p_Log_Exception boolean default true)
147 return varchar2;
148
149
150 function Get_Level_IRID(p_Dimension_IRID number
151 ,p_Level_Name varchar2
152 ,p_Log_Exception boolean default true
153 ,p_For_Update boolean default false
154 ,p_Wait_For_Lock boolean default false)
155 return number;
156
157 procedure Drop_Level(p_Level_IRID number);
158
159 procedure Drop_Level_D_IRID(p_Dimension_IRID number);
160
161
162 --Hierarchy
163 function Get_Hierarchy_Name(p_Hierarchy_IRID number
164 ,p_Log_Exception boolean default true)
165 return varchar2;
166
167
168 function Get_Hierarchy_IRID(p_Dimension_IRID number
169 ,p_Hierarchy_Name varchar2
170 ,p_Log_Exception boolean default true
171 ,p_For_Update boolean default false
172 ,p_Wait_For_Lock boolean default false)
173 return number;
174
175 procedure Drop_Hierarchy(p_Hierarchy_IRID number);
176
177 procedure Drop_Hierarchy_D_IRID(p_Dimension_IRID number);
178
179
180 --CubeDimensionUse
181 function Get_CubeDimensionUse_IRID(p_Cube_IRID number
182 ,p_Dimension_IRID number
183 ,p_Log_Exception boolean default true)
184 return number;
185
186 procedure Drop_CubeDimensionUse(p_CubeDimensionUse_IRID number);
187
188 procedure Drop_CubeDimensionUse_C_IRID(p_Cube_IRID number);
189
190 procedure Drop_CubeDimensionUse_D_IRID(p_Dimension_IRID number);
191
192
193 --DimensionAttribute
194 function Get_DimensionAttribute_Name(p_DimensionAttribute_IRID number
195 ,p_Log_Exception boolean default true)
196 return varchar2;
197
198 function Get_DimensionAttribute_IRID(p_Dimension_IRID number
199 ,p_DimensionAttribute_Name varchar2
200 ,p_Log_Exception boolean default true
201 ,p_For_Update boolean default false
202 ,p_Wait_For_Lock boolean default false)
203 return number;
204
205 procedure Drop_DimensionAttribute(p_DimensionAttribute_IRID number);
206
207 procedure Drop_DimensionAttr_D_IRID(p_Dimension_IRID number);
208
209
210 --Dimension
211 function Get_Dimension_Name(p_Dimension_IRID number
212 ,p_Log_Exception boolean default true)
213 return varchar2;
214
215 function Get_Dimension_IRID(p_Dimension_Owner varchar2
216 ,p_Dimension_Name varchar2
217 ,p_Log_Exception boolean default true
218 ,p_For_Update boolean default false
219 ,p_Wait_For_Lock boolean default false)
220 return number;
221
222 procedure Drop_Dimension(p_Dimension_IRID number);
223
224
225
226 --Cube
227 function Get_Cube_Name(p_Cube_IRID number
228 ,p_Log_Exception boolean default true)
229 return varchar2;
230
231 function Get_Cube_IRID(p_Cube_Owner varchar2
232 ,p_Cube_Name varchar2
233 ,p_Log_Exception boolean default true
234 ,p_For_Update boolean default false
235 ,p_Wait_For_Lock boolean default false)
236 return number;
237
238 procedure Drop_Cube(p_Cube_IRID number);
239
240
241
242 --Invalid
243 procedure Set_Cube_Invalid(p_Cube_IRID number);
244
245 procedure Set_Cube_Invalid_D_IRID(p_Dimension_IRID number);
246
247 procedure Set_Cube_Invalid_M_IRID(p_Measure_IRID number);
248
249 procedure Set_Dimension_Invalid(p_Dimension_IRID number);
250
251 procedure Set_Dimension_Invalid_H_IRID(p_Hierarchy_IRID number);
252
253 procedure Set_Dimension_Invalid_L_IRID(p_Level_IRID number);
257 -- get class entry irid given element irid and class irid
254
255 --Class Entry i.e. Classification Entry
256
258 function Get_Class_Entry_IRID_EC_IRID(p_Element_IRID number
259 ,p_Class_IRID number
260 ,p_Name varchar2
261 ,p_Log_Exception boolean default true
262 ,p_For_Update boolean default false
263 ,p_Wait_For_Lock boolean default false)
264 return number;
265
266 -- get class entry irid given element irid
267 function Get_Class_Entry_IRID_E_IRID(p_Element_IRID number
268 ,p_Name varchar2
269 ,p_Log_Exception boolean default true
270 ,p_For_Update boolean default false
271 ,p_Wait_For_Lock boolean default false)
272 return number;
273
274 procedure Drop_Class_Entry_Element(p_IRID number
275 ,p_Name varchar2);
276
277 procedure Drop_Class_Entry_Class(p_IRID number
278 ,p_Name varchar2);
279
280 procedure Drop_Class_Entry(p_IRID number
281 ,p_Name varchar2);
282
283 --Class Type i.e. Classification Type
284 function Get_Class_Type_IRID(p_Log_Exception boolean default true
285 ,p_For_Update boolean default false)
286 return number;
287
288 --Class i.e. Classification
289 function Get_Class_Name(p_Class_IRID number
290 ,p_Log_Exception boolean default true)
291 return varchar2;
292
293 function Get_Class_IRID(p_Class_Name varchar2
294 ,p_Log_Exception boolean default true
295 ,p_For_Update boolean default false
296 ,p_Wait_For_Lock boolean default false)
297 return number;
298
299 procedure Drop_Class(p_Class_IRID number);
300
301 --Project
302 function Get_Project_IRID(p_Log_Exception boolean default true
303 ,p_For_Update boolean default false)
304 return number;
305
306 -- DBMS_OUTPUT mgmt procedures
307 procedure clear_dbmsoutput_buffer;
308
309 procedure dump_dbmsoutput_buffer(p_directory_alias varchar2,
310 p_file_name varchar2);
311
312
313 -- check parameter max length
314 procedure Check_Parameter_Max_Length(p_Parameter_Name varchar2
315 ,p_Parameter_Value varchar2
316 ,p_Parameter_Max_Length number
317 ,p_Wildcard_Allowed varchar2);
318
319 -- check parameter of type name
320 function Check_Name_Type_Parameter(p_Parameter_Name varchar2
321 ,p_Parameter_Value varchar2
322 ,p_Parameter_Wildcard_Allowed varchar2 default 'NO'
323 ) return varchar2;
324
325 -- turn off debug switch (production mode). if a name is not provided all switches are set off.
326 procedure Set_Debug_Off(p_Switch_Name varchar2 default null);
327
328 -- turn on debug switch (debuging mode). if a name is not provided all switches are set on.
329 procedure Set_Debug_On(p_Switch_Name varchar2 default null);
330
331 end cwm2_olap_utility;