[Home] [Help]
268: if ( aw_count > 0 ) then
269:
270: dbms_cube.import_xml( to_clob(
271: '
272:
273:
274:
275:
276:
269:
270: dbms_cube.import_xml( to_clob(
271: '
272:
273:
274:
275:
276:
277:
270: dbms_cube.import_xml( to_clob(
271: '
272:
273:
274:
275:
276:
277:
278:
271: '
272:
273:
274:
275:
276:
277:
278:
279:
272:
273:
274:
275:
276:
277:
278:
279:
280:
273:
274:
275:
276:
277:
278:
279:
280:
281:
274:
275:
276:
277:
278:
279:
280:
281:
282:
275:
276:
277:
278:
279:
280:
281:
282:
283:
276:
277:
278:
279:
280:
281:
282:
283:
284:
277:
278:
279:
280:
281:
282:
283:
284:
285: '));
302:
303: pa_olap_pvt.add_lob_line('
305: pa_olap_pvt.add_lob_line(' MinimumDatabaseVersion="11.2.0.2"> ');
306: pa_olap_pvt.add_lob_line('
308: pa_olap_pvt.add_lob_line(' ETViewName="PA_CALENDAR_TYPE_VIEW" ');
309: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
310: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
386: pa_olap_pvt.add_lob_line(' Type="Description" ');
387: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
388: pa_olap_pvt.add_lob_line(' Value="PA CALENDAR TYPE"> ');
389: pa_olap_pvt.add_lob_line(' ');
390: pa_olap_pvt.add_lob_line(' ');
391: pa_olap_pvt.add_lob_line(' ');
392: pa_olap_pvt.add_lob_line('
394: pa_olap_pvt.add_lob_line(' ETViewName="PA_CBS_ELEMENTS_DM_VIEW" ');
388: pa_olap_pvt.add_lob_line(' Value="PA CALENDAR TYPE"> ');
389: pa_olap_pvt.add_lob_line(' ');
390: pa_olap_pvt.add_lob_line(' ');
391: pa_olap_pvt.add_lob_line(' ');
392: pa_olap_pvt.add_lob_line('
394: pa_olap_pvt.add_lob_line(' ETViewName="PA_CBS_ELEMENTS_DM_VIEW" ');
395: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
396: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
460: pa_olap_pvt.add_lob_line(' Type="Description" ');
461: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
462: pa_olap_pvt.add_lob_line(' Value="PA CBS ELEMENTS DM"> ');
463: pa_olap_pvt.add_lob_line(' ');
464: pa_olap_pvt.add_lob_line(' ');
465: pa_olap_pvt.add_lob_line(' ');
466: pa_olap_pvt.add_lob_line('
468: pa_olap_pvt.add_lob_line(' ETViewName="PA_CBS_VERSIONS_DM_VIEW" ');
462: pa_olap_pvt.add_lob_line(' Value="PA CBS ELEMENTS DM"> ');
463: pa_olap_pvt.add_lob_line(' ');
464: pa_olap_pvt.add_lob_line(' ');
465: pa_olap_pvt.add_lob_line(' ');
466: pa_olap_pvt.add_lob_line('
468: pa_olap_pvt.add_lob_line(' ETViewName="PA_CBS_VERSIONS_DM_VIEW" ');
469: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
470: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
546: pa_olap_pvt.add_lob_line(' Type="Description" ');
547: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
548: pa_olap_pvt.add_lob_line(' Value="PA CBS VERSIONS DM"> ');
549: pa_olap_pvt.add_lob_line(' ');
550: pa_olap_pvt.add_lob_line(' ');
551: pa_olap_pvt.add_lob_line(' ');
552: pa_olap_pvt.add_lob_line('
554: pa_olap_pvt.add_lob_line(' ETViewName="PA_CURRENCY_DM_VIEW" ');
548: pa_olap_pvt.add_lob_line(' Value="PA CBS VERSIONS DM"> ');
549: pa_olap_pvt.add_lob_line(' ');
550: pa_olap_pvt.add_lob_line(' ');
551: pa_olap_pvt.add_lob_line(' ');
552: pa_olap_pvt.add_lob_line('
554: pa_olap_pvt.add_lob_line(' ETViewName="PA_CURRENCY_DM_VIEW" ');
555: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
556: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
632: pa_olap_pvt.add_lob_line(' Type="Description" ');
633: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
634: pa_olap_pvt.add_lob_line(' Value="PA CURRENCY DM"> ');
635: pa_olap_pvt.add_lob_line(' ');
636: pa_olap_pvt.add_lob_line(' ');
637: pa_olap_pvt.add_lob_line(' ');
638: pa_olap_pvt.add_lob_line('
640: pa_olap_pvt.add_lob_line(' ETViewName="PA_PLAN_VERSIONS_DM_VIEW" ');
634: pa_olap_pvt.add_lob_line(' Value="PA CURRENCY DM"> ');
635: pa_olap_pvt.add_lob_line(' ');
636: pa_olap_pvt.add_lob_line(' ');
637: pa_olap_pvt.add_lob_line(' ');
638: pa_olap_pvt.add_lob_line('
640: pa_olap_pvt.add_lob_line(' ETViewName="PA_PLAN_VERSIONS_DM_VIEW" ');
641: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
642: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
718: pa_olap_pvt.add_lob_line(' Type="Description" ');
719: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
720: pa_olap_pvt.add_lob_line(' Value="PA PLAN VERSIONS DM"> ');
721: pa_olap_pvt.add_lob_line(' ');
722: pa_olap_pvt.add_lob_line(' ');
723: pa_olap_pvt.add_lob_line(' ');
724: pa_olap_pvt.add_lob_line('
726: pa_olap_pvt.add_lob_line(' ETViewName="PA_PROJECT_DIM_VIEW" ');
720: pa_olap_pvt.add_lob_line(' Value="PA PLAN VERSIONS DM"> ');
721: pa_olap_pvt.add_lob_line(' ');
722: pa_olap_pvt.add_lob_line(' ');
723: pa_olap_pvt.add_lob_line(' ');
724: pa_olap_pvt.add_lob_line('
726: pa_olap_pvt.add_lob_line(' ETViewName="PA_PROJECT_DIM_VIEW" ');
727: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
728: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
841: pa_olap_pvt.add_lob_line(' Type="Description" ');
842: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
843: pa_olap_pvt.add_lob_line(' Value="PA PROJECT DIM"> ');
844: pa_olap_pvt.add_lob_line(' ');
845: pa_olap_pvt.add_lob_line(' ');
846: pa_olap_pvt.add_lob_line(' ');
847: pa_olap_pvt.add_lob_line('
849: pa_olap_pvt.add_lob_line(' ETViewName="PA_RBS_ELEMENTS_DM_VIEW" ');
843: pa_olap_pvt.add_lob_line(' Value="PA PROJECT DIM"> ');
844: pa_olap_pvt.add_lob_line(' ');
845: pa_olap_pvt.add_lob_line(' ');
846: pa_olap_pvt.add_lob_line(' ');
847: pa_olap_pvt.add_lob_line('
849: pa_olap_pvt.add_lob_line(' ETViewName="PA_RBS_ELEMENTS_DM_VIEW" ');
850: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
851: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
915: pa_olap_pvt.add_lob_line(' Type="Description" ');
916: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
917: pa_olap_pvt.add_lob_line(' Value="PA RBS ELEMENTS DM"> ');
918: pa_olap_pvt.add_lob_line(' ');
919: pa_olap_pvt.add_lob_line(' ');
920: pa_olap_pvt.add_lob_line(' ');
921: pa_olap_pvt.add_lob_line('
923: pa_olap_pvt.add_lob_line(' ETViewName="PA_RBS_VERSIONS_DM_VIEW" ');
917: pa_olap_pvt.add_lob_line(' Value="PA RBS ELEMENTS DM"> ');
918: pa_olap_pvt.add_lob_line(' ');
919: pa_olap_pvt.add_lob_line(' ');
920: pa_olap_pvt.add_lob_line(' ');
921: pa_olap_pvt.add_lob_line('
923: pa_olap_pvt.add_lob_line(' ETViewName="PA_RBS_VERSIONS_DM_VIEW" ');
924: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
925: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
1001: pa_olap_pvt.add_lob_line(' Type="Description" ');
1002: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
1003: pa_olap_pvt.add_lob_line(' Value="PA RBS VERSIONS DM"> ');
1004: pa_olap_pvt.add_lob_line(' ');
1005: pa_olap_pvt.add_lob_line(' ');
1006: pa_olap_pvt.add_lob_line(' ');
1007: pa_olap_pvt.add_lob_line('
1009: pa_olap_pvt.add_lob_line(' ETViewName="PA_TASK_DM_VIEW" ');
1003: pa_olap_pvt.add_lob_line(' Value="PA RBS VERSIONS DM"> ');
1004: pa_olap_pvt.add_lob_line(' ');
1005: pa_olap_pvt.add_lob_line(' ');
1006: pa_olap_pvt.add_lob_line(' ');
1007: pa_olap_pvt.add_lob_line('
1009: pa_olap_pvt.add_lob_line(' ETViewName="PA_TASK_DM_VIEW" ');
1010: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
1011: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
1075: pa_olap_pvt.add_lob_line(' Type="Description" ');
1076: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
1077: pa_olap_pvt.add_lob_line(' Value="PA TASK DM"> ');
1078: pa_olap_pvt.add_lob_line(' ');
1079: pa_olap_pvt.add_lob_line(' ');
1080: pa_olap_pvt.add_lob_line(' ');
1081: pa_olap_pvt.add_lob_line('
1083: pa_olap_pvt.add_lob_line(' ETViewName="PA_TIME_DM_VIEW" ');
1077: pa_olap_pvt.add_lob_line(' Value="PA TASK DM"> ');
1078: pa_olap_pvt.add_lob_line(' ');
1079: pa_olap_pvt.add_lob_line(' ');
1080: pa_olap_pvt.add_lob_line(' ');
1081: pa_olap_pvt.add_lob_line('
1083: pa_olap_pvt.add_lob_line(' ETViewName="PA_TIME_DM_VIEW" ');
1084: pa_olap_pvt.add_lob_line(' ETKeyColumnName="DIM_KEY" ');
1085: pa_olap_pvt.add_lob_line(' ETLevelColumnName="LEVEL_NAME" ');
1250: pa_olap_pvt.add_lob_line(' Type="Description" ');
1251: pa_olap_pvt.add_lob_line(' Language="AMERICAN" ');
1252: pa_olap_pvt.add_lob_line(' Value="PA TIME DM"> ');
1253: pa_olap_pvt.add_lob_line(' ');
1254: pa_olap_pvt.add_lob_line(' ');
1255: pa_olap_pvt.add_lob_line(' ');
1256: pa_olap_pvt.add_lob_line('
1258: pa_olap_pvt.add_lob_line(' Name="PA_AC_ACTUAL_CUBE" ');