Running OLAP Builds to Load Data into Analytical Workspace

Read the document firstly
https://docs.oracle.com/cd/E64694_01/CDMIG/E64550-04.pdf

This load typically completes in 30-35 minutes.
[oracle@PTUD-S07 ~]$ sqlplus ocdm_sample/*********@orcl

SQL*Plus: Release 12.1.0.1.0 Production on Thu Dec 3 14:56:25 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Last Successful login time: Thu Dec 03 2015 14:03:22 +07:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> begin
pkg_ocdm_olap_etl_aw_load.run;
end;
/

PL/SQL procedure successfully completed.

SQL> select cubename,load_status,error_dtl from dwc_olap_activity order by
cubename; 

ACM COMPLETED-SUCCESS
ADM COMPLETED-SUCCESS
AGRMNT COMPLETED-SUCCESS
APM COMPLETED-SUCCESS
CCM COMPLETED-SUCCESS
CHRN COMPLETED-SUCCESS
CMSN COMPLETED-SUCCESS
COM COMPLETED-SUCCESS
CSM COMPLETED-SUCCESS
IAM COMPLETED-SUCCESS
INV COMPLETED-SUCCESS
INVCM COMPLETED-SUCCESS
RVN COMPLETED-SUCCESS
SLS COMPLETED-SUCCESS
14 rows selected.

Tweet