[Home] [Help]
PACKAGE: OLAPSYS.DBMS_AWM
Source
1 package DBMS_AWM authid current_user as
2
3 -- MAINTAIN AWDimLoad Spec
4 procedure Create_AWDimLoad_Spec(p_AWDimLoad_Spec_Name varchar2
5 ,p_Dimension_Owner varchar2
6 ,p_Dimension_Name varchar2
7 ,p_LoadType_Name varchar2
8 );
9
10 procedure Delete_AWDimLoad_Spec(p_AWDimLoad_Spec_Name varchar2
11 ,p_Dimension_Owner varchar2
12 ,p_Dimension_Name varchar2
13 );
14
15
16
17 procedure Set_AWDimLoad_Spec_Name(p_AWDimLoad_Spec_Name varchar2
18 ,p_Dimension_Owner varchar2
19 ,p_Dimension_Name varchar2
20 ,p_Set_AWDimLoad_Spec_Name varchar2
21 );
22
23 procedure Set_AWDimLoad_Spec_Dimension(p_AWDimLoad_Spec_Name varchar2
24 ,p_Dimension_Owner varchar2
25 ,p_Dimension_Name varchar2
26 ,p_Set_Dimension_Owner varchar2
27 ,p_Set_Dimension_Name varchar2
28 );
29
30 procedure Set_AWDimLoad_Spec_LoadType(p_AWDimLoad_Spec_Name varchar2
31 ,p_Dimension_Owner varchar2
32 ,p_Dimension_Name varchar2
33 ,p_LoadType_Name varchar2
34 );
35
36
37 procedure Add_AWDimLoad_Spec_Filter(p_AWDimLoad_Spec_Name varchar2
38 ,p_Dimension_Owner varchar2
39 ,p_Dimension_Name varchar2
40 ,p_Lookup_Table_Owner varchar2
41 ,p_Lookup_Table_Name varchar2
42 ,p_Where_Clause varchar2
43 );
44
45
46 procedure Delete_AWDimLoad_Spec_Filter(p_AWDimLoad_Spec_Name varchar2
47 ,p_Dimension_Owner varchar2
48 ,p_Dimension_Name varchar2
49 ,p_Lookup_Table_Owner varchar2
50 ,p_Lookup_Table_Name varchar2
51 );
52
53
54
55 procedure Set_AWDimLoad_Spec_Parameter(p_AWDimLoad_Spec_Name varchar2
56 ,p_Dimension_Owner varchar2
57 ,p_Dimension_Name varchar2
58 ,p_Parameter_Name varchar2
59 ,p_Parameter_Value varchar2 default null
60 );
61
62
63
64 -- MAINTAIN AWCubeLoad Spec
65 procedure Create_AWCubeLoad_Spec(p_AWCubeLoad_Spec_Name varchar2
66 ,p_Cube_Owner varchar2
67 ,p_Cube_Name varchar2
68 ,p_LoadType_Name varchar2
69 );
70
71
72 procedure Delete_AWCubeLoad_Spec(p_AWCubeLoad_Spec_Name varchar2
73 ,p_Cube_Owner varchar2
74 ,p_Cube_Name varchar2
75 );
76
77
78
79
80 procedure Set_AWCubeLoad_Spec_Name(p_AWCubeLoad_Spec_Name varchar2
81 ,p_Cube_Owner varchar2
82 ,p_Cube_Name varchar2
83 ,p_Set_AWCubeLoad_Spec_Name varchar2
84 );
85
86
87 procedure Set_AWCubeLoad_Spec_Cube(p_AWCubeLoad_Spec_Name varchar2
88 ,p_Cube_Owner varchar2
89 ,p_Cube_Name varchar2
90 ,p_Set_Cube_Owner varchar2
91 ,p_Set_Cube_Name varchar2
92 );
93
94
95 procedure Set_AWCubeLoad_Spec_LoadType(p_AWCubeLoad_Spec_Name varchar2
96 ,p_Cube_Owner varchar2
97 ,p_Cube_Name varchar2
98 ,p_LoadType_Name varchar2
99 );
100
101
102 procedure Add_AWCubeLoad_Spec_Filter(p_AWCubeLoad_Spec_Name varchar2
103 ,p_Cube_Owner varchar2
104 ,p_Cube_Name varchar2
105 ,p_Fact_Table_Owner varchar2
106 ,p_Fact_Table_Name varchar2
107 ,p_Where_Clause varchar2
108 );
109
110
111 procedure Delete_AWCubeLoad_Spec_Filter(p_AWCubeLoad_Spec_Name varchar2
112 ,p_Cube_Owner varchar2
113 ,p_Cube_Name varchar2
114 ,p_Fact_Table_Owner varchar2
115 ,p_Fact_Table_Name varchar2
116 );
117
118 procedure Add_AWCubeLoad_Spec_Measure(p_AWCubeLoad_Spec_Name varchar2
119 ,p_Cube_Owner varchar2
120 ,p_Cube_Name varchar2
121 ,p_Measure_Name varchar2
122 ,p_TargetName varchar2 default null
123 ,p_TargetDisplayName varchar2 default null
124 ,p_TargetDescription varchar2 default null
125 );
126
127 procedure Delete_AWCubeLoad_Spec_Measure(p_AWCubeLoad_Spec_Name varchar2
128 ,p_Cube_Owner varchar2
129 ,p_Cube_Name varchar2
130 ,p_Measure_Name varchar2
131 );
132
133 procedure Set_AWCubeLoad_Spec_Parameter(p_AWCubeLoad_Spec_Name varchar2
134 ,p_Cube_Owner varchar2
135 ,p_Cube_Name varchar2
136 ,p_Parameter_Name varchar2
137 ,p_Parameter_Value varchar2 default null
138 );
139
140 -- AW AggPlans
141 procedure Create_AWCubeAgg_Spec(p_AWCubeAgg_Spec_Name varchar2
142 ,p_Cube_Owner varchar2
143 ,p_AW_Name varchar2
144 ,p_Cube_Name varchar2
145 );
146
147 procedure Add_AWCubeAgg_Spec_Level(p_AWCubeAgg_Spec_Name varchar2
148 ,p_Cube_Owner varchar2
149 ,p_AW_Name varchar2
150 ,p_Cube_Name varchar2
151 ,p_Dimension_Name varchar2
152 ,p_Level_Name varchar2
153 );
154
155 procedure Set_AWCubeAgg_Spec_Aggop(p_AWCubeAgg_Spec_Name varchar2
156 ,p_Cube_Owner varchar2
157 ,p_AW_Name varchar2
158 ,p_Cube_Name varchar2
159 ,p_Measure_Name varchar2
160 ,p_Dimension_Name varchar2
161 ,p_Operator varchar2
162 );
163
164 procedure Add_AWCubeAgg_Spec_Measure(p_AWCubeAgg_Spec_Name varchar2
165 ,p_Cube_Owner varchar2
166 ,p_AW_Name varchar2
167 ,p_Cube_Name varchar2
168 ,p_Measure_Name varchar2
169 );
170
171 procedure Delete_AWCubeAgg_Spec(p_AWCubeAgg_Spec_Name varchar2
172 ,p_Cube_Owner varchar2
173 ,p_AW_Name varchar2
174 ,p_Cube_Name varchar2
175 );
176
177 procedure Delete_AWCubeAgg_Spec_Level(p_AWCubeAgg_Spec_Name varchar2
178 ,p_Cube_Owner varchar2
179 ,p_AW_Name varchar2
180 ,p_Cube_Name varchar2
181 ,p_Dimension_Name varchar2
182 ,p_Level_Name varchar2
183 );
184
185 procedure Delete_AWCubeAgg_Spec_Measure(p_AWCubeAgg_Spec_Name varchar2
186 ,p_Cube_Owner varchar2
187 ,p_AW_Name varchar2
188 ,p_Cube_Name varchar2
189 ,p_Measure_Name varchar2
190 );
191
192
193
194
195 -- MAINTAIN MVCubeAgg Spec
196 procedure Create_MVCubeAgg_Spec(p_AWCubeAgg_Spec_Name varchar2
197 ,p_Cube_Owner varchar2
198 ,p_Cube_Name varchar2
199 );
200
201
202 procedure Delete_MVCubeAgg_Spec(p_AWCubeAgg_Spec_Name varchar2
203 ,p_Cube_Owner varchar2
204 ,p_Cube_Name varchar2
205 );
206
207
208
209 procedure Set_MVCubeAgg_Spec_Name(p_AWCubeAgg_Spec_Name varchar2
210 ,p_Cube_Owner varchar2
211 ,p_Cube_Name varchar2
212 ,p_Set_AWCubeAgg_spec_Name varchar2
213 );
214
215
216 procedure Set_MVCubeAgg_Spec_Cube(p_AWCubeAgg_Spec_Name varchar2
217 ,p_Cube_Owner varchar2
218 ,p_Cube_Name varchar2
219 ,p_Set_Cube_Owner varchar2
220 ,p_Set_Cube_Name varchar2
221 );
222
223
224 procedure Add_MVCubeAgg_Spec_Measure(p_AWCubeAgg_Spec_Name varchar2
225 ,p_Cube_Owner varchar2
226 ,p_Cube_Name varchar2
227 ,p_Measure_Name varchar2
228 );
229
230
231 procedure Delete_MVCubeAgg_Spec_Measure(p_AWCubeAgg_Spec_Name varchar2
232 ,p_Cube_Owner varchar2
233 ,p_Cube_Name varchar2
234 ,p_Measure_Name varchar2
235 );
236
237
238 procedure Add_MVCubeAgg_Spec_Level(p_AWCubeAgg_Spec_Name varchar2
239 ,p_Cube_Owner varchar2
240 ,p_Cube_Name varchar2
241 ,p_Dimension_Owner varchar2
242 ,p_Dimension_Name varchar2
243 ,p_Level_Name varchar2
244 );
245
246
247 procedure Delete_MVCubeAgg_Spec_Level(p_AWCubeAgg_Spec_Name varchar2
248 ,p_Cube_Owner varchar2
249 ,p_Cube_Name varchar2
250 ,p_Dimension_Owner varchar2
251 ,p_Dimension_Name varchar2
252 ,p_Level_Name varchar2
253 );
254
255
256
257 -- MAINTAIN AWComp Spec
258 procedure Create_AWComp_Spec(p_AWComp_Spec_Name varchar2
259 ,p_Cube_Owner varchar2
260 ,p_Cube_Name varchar2
261 );
262
263 procedure Delete_AWComp_Spec(p_AWComp_Spec_Name varchar2
264 ,p_Cube_Owner varchar2
265 ,p_Cube_Name varchar2
266 );
267
268 procedure Set_AWComp_Spec_Name(p_AWComp_Spec_Name varchar2
269 ,p_Cube_Owner varchar2
270 ,p_Cube_Name varchar2
271 ,p_Set_AWComp_Spec_Name varchar2
272 );
273
274 procedure Set_AWComp_Spec_Cube(p_AWComp_Spec_Name varchar2
275 ,p_Cube_Owner varchar2
276 ,p_Cube_Name varchar2
277 ,p_Set_Cube_Owner varchar2
278 ,p_Set_Cube_Name varchar2
279 );
280
281
282
283 -- MAINTAIN AWComp Spec Member
284 procedure Add_AWComp_Spec_Member(p_AWComp_Spec_Name varchar2
285 ,p_Cube_Owner varchar2
286 ,p_Cube_Name varchar2
287 ,p_Member_Name varchar2
288 ,p_Member_Type varchar2 -- 'DIMENSION' or 'COMPOSITE'
289 ,p_Dimension_Owner varchar2 default null
293 procedure Delete_AWComp_Spec_Member(p_AWComp_Spec_Name varchar2
290 ,p_Dimension_Name varchar2 default null
291 );
292
294 ,p_Cube_Owner varchar2
295 ,p_Cube_Name varchar2
296 ,p_Member_Name varchar2
297 );
298
299
300
301 procedure Set_AWComp_Spec_Member_Name(p_AWComp_Spec_Name varchar2
302 ,p_Cube_Owner varchar2
303 ,p_Cube_Name varchar2
304 ,p_Member_Name varchar2
305 ,p_Set_Member_Name varchar2
306 );
307
308 procedure Set_AWComp_Spec_Member_Pos(p_AWComp_Spec_Name varchar2
309 ,p_Cube_Owner varchar2
310 ,p_Cube_Name varchar2
311 ,p_Member_Name varchar2
312 ,p_Member_Posistion number
313 );
314
315 procedure Set_AWComp_Spec_Member_Seg(p_AWComp_Spec_Name varchar2
316 ,p_Cube_Owner varchar2
317 ,p_Cube_Name varchar2
318 ,p_Member_Name varchar2
319 ,p_Member_Segwidth number default null
320 );
321
322
323 /* AWComp Spec Como Members must be add in order */
324 procedure Add_AWComp_Spec_Comp_Member(p_AWComp_Spec_Name varchar2
325 ,p_Cube_Owner varchar2
326 ,p_Cube_Name varchar2
327 ,p_Member_Name varchar2
328 ,p_Nested_Member_Name varchar2
329 ,p_Nested_Member_Type varchar2 -- 'DIMENSION' or 'COMPOSITE'
330 ,p_Dimension_Owner varchar2 default null
331 ,p_Dimension_Name varchar2 default null
332 );
333
334
335
336 procedure Add_MVCubeLoad_Spec_Agg(p_AWCubeLoad_Spec_Name varchar2
337 ,p_Cube_Owner varchar2
338 ,p_Cube_Name varchar2
339 ,p_AWCubeAgg_Spec_Name varchar2
340 );
341
342 procedure Delete_MVCubeLoad_Spec_Agg(p_AWCubeLoad_Spec_Name varchar2
343 ,p_Cube_Owner varchar2
344 ,p_Cube_Name varchar2
345 ,p_AWCubeAgg_Spec_Name varchar2
346 );
347
348 procedure Add_AWCubeLoad_Spec_Comp(p_AWCubeLoad_Spec_Name varchar2
349 ,p_Cube_Owner varchar2
350 ,p_Cube_Name varchar2
351 ,p_AWComp_Spec_Name varchar2
352 );
353
354 procedure Delete_AWCubeLoad_Spec_Comp(p_AWCubeLoad_Spec_Name varchar2
355 ,p_Cube_Owner varchar2
356 ,p_Cube_Name varchar2
357 ,p_AWComp_Spec_Name varchar2
358 );
359
360
361 procedure Create_AWDimension(p_Source_Dimension_Owner varchar2
362 ,p_Source_Dimension_Name varchar2
363 ,p_AW_Owner varchar2
364 ,p_AW_Name varchar2
365 ,p_Target_Dimension_Name varchar2 default null
366 ,p_SkipChecks varchar2 default null
367 );
368
369
370 procedure Refresh_AWDimension(p_AW_Owner varchar2
371 ,p_AW_Name varchar2
372 ,p_Target_Dimension_Name varchar2
373 ,p_AWDimLoad_Spec_Name varchar2 default null
374 );
375
376
377
378 procedure Create_AWCube(p_Source_Cube_Owner varchar2
379 ,p_Source_Cube_Name varchar2
380 ,p_AW_Owner varchar2
381 ,p_AW_Name varchar2
382 ,p_Target_Cube_Name varchar2 default null
383 ,p_SkipChecks varchar2 default null
384 );
385
386
387 procedure Refresh_AWCube(p_AW_Owner varchar2
388 ,p_AW_Name varchar2
389 ,p_Target_Cube_Name varchar2
390 ,p_AWCubeLoad_Spec_Name varchar2 default null
391 );
392
393 procedure Aggregate_AWCube(p_AW_Owner varchar2
394 ,p_AW_Name varchar2
395 ,p_Target_Cube_Name varchar2
396 ,p_AWCubeAgg_Spec_Name varchar2
397 );
398
399
400 --
401 -- OLAP Enabler APIs
402 -- Supports both AWM Integration and standalone script
403 -- generation.
404 --
405
406 procedure create_awdimension_access(p_AW_Owner varchar2,
407 p_AW_Name varchar2,
408 p_Target_Dimension_Name varchar2,
409 p_Access_Type varchar2,
410 p_Script_Directory varchar2,
411 p_Script_Name varchar2,
412 p_OpenMode varchar2,
416
413 p_Caller varchar2 default null,
414 p_SpreadsheetMode varchar2 default 'YES',
415 p_AutoAdtMode varchar2 default 'YES');
417
418 procedure create_awdimension_access(p_runid number,
419 p_AW_Owner varchar2,
420 p_AW_Name varchar2,
421 p_Target_Dimension_Name varchar2,
422 p_Access_Type varchar2,
423 p_SpreadsheetMode varchar2 default 'YES',
424 p_AutoAdtMode varchar2 default 'YES');
425
426
427 procedure create_awcube_access(p_AW_Owner varchar2,
428 p_AW_Name varchar2,
429 p_Target_Cube_Name varchar2,
430 p_Access_Type varchar2,
431 p_Script_Directory varchar2,
432 p_Script_Name varchar2,
433 p_OpenMode varchar2,
434 p_Caller varchar2 default null,
435 p_SpreadsheetMode varchar2 default 'YES',
436 p_AutoAdtMode varchar2 default 'YES');
437
438
439 procedure create_awcube_access(p_runid number,
440 p_AW_Owner varchar2,
441 p_AW_Name varchar2,
442 p_Target_Cube_Name varchar2,
443 p_Access_Type varchar2,
444 p_SpreadsheetMode varchar2 default 'YES',
445 p_AutoAdtMode varchar2 default 'YES');
446
447
448
449 procedure delete_awdimension_access(p_AW_Owner varchar2,
450 p_AW_Name varchar2,
451 p_Target_Dimension_Name varchar2,
452 p_Access_Type varchar2,
453 p_Script_Directory varchar2,
454 p_Script_Name varchar2,
455 p_OpenMode varchar2);
456
457
458 procedure delete_awdimension_access(p_runid number,
459 p_AW_Owner varchar2,
460 p_AW_Name varchar2,
461 p_Target_Dim_Name varchar2,
462 p_Access_Type varchar2,
463 p_caller varchar2 default null);
464
465
466 procedure delete_awcube_access(p_AW_Owner varchar2,
467 p_AW_Name varchar2,
468 p_Target_Cube_Name varchar2,
469 p_Access_Type varchar2,
470 p_Script_Directory varchar2,
471 p_Script_Name varchar2,
472 p_OpenMode varchar2);
473
474
475 procedure delete_awcube_access(p_runid number,
476 p_AW_Owner varchar2,
477 p_AW_Name varchar2,
478 p_Target_Cube_Name varchar2,
479 p_Access_Type varchar2,
480 p_caller varchar2 default null);
481
482
483 procedure set_awdimension_view_name(p_AWOwner varchar2,
484 p_AWName varchar2,
485 p_DimName varchar2,
486 p_HierName varchar2,
487 p_UserViewName varchar2);
488
489 procedure set_awcube_view_name(p_AWOwner varchar2,
490 p_AWName varchar2,
491 p_CubeName varchar2,
492 p_HierComboNum number,
493 p_UserViewName varchar2);
494
495
496 procedure delete_all_aw_access(p_runid number,
497 p_AWOwner varchar2,
498 p_AWName varchar2);
499
500
501
502 procedure create_awdimension_access_full(p_runid number,
503 p_AW_Owner varchar2,
504 p_AW_Name varchar2,
505 p_Target_Dimension_Name varchar2,
506 p_Access_Type varchar2,
507 p_SpreadsheetMode varchar2 default 'YES',
508 p_AutoAdtMode varchar2 default 'YES');
509
510 procedure create_awcube_access_full(p_runid number,
511 p_AW_Owner varchar2,
512 p_AW_Name varchar2,
513 p_Target_Cube_Name varchar2,
514 p_Access_Type varchar2,
515 p_SpreadsheetMode varchar2 default 'YES',
516 p_AutoAdtMode varchar2 default 'YES');
517
518
519 procedure delete_awdimension_access_all(p_runid number,
520 p_AW_Owner varchar2,
521 p_AW_Name varchar2,
522 p_Target_Dim_Name varchar2,
523 p_Access_Type varchar2);
524
525 procedure delete_awcube_access_all(p_runid number,
526 p_AW_Owner varchar2,
527 p_AW_Name varchar2,
528 p_Target_Cube_Name varchar2,
529 p_Access_Type varchar2);
530
531
532 procedure refresh_awdimension_view_name(p_AW_Owner varchar2,
533 p_AW_Name varchar2,
534 p_DimName varchar2);
535
536 procedure refresh_awcube_view_name(p_AW_Owner varchar2,
537 p_AW_Name varchar2,
538 p_CubeName varchar2);
539
540 procedure create_dynamic_aw_access(p_AW_Owner varchar2,
541 p_AW_Name varchar2);
542
543 procedure upgrade_aw_to_10_2(p_AW_Owner varchar2,
544 p_AW_Name varchar2,
545 p_AWM_Caller varchar2 default 'NO');
546
547 procedure create_schedule_job(p_JobName varchar2,
548 p_JobAction varchar2,
549 p_NumberOfArgs number,
550 p_StartTime timestamp,
551 p_Comments varchar2);
552
553 end DBMS_AWM;