Initial Star Schema Load

After existing historical data is replicated from the source into the Oracle Utilities Analytics Warehouse Analytics replication layer, Dimensions, Facts and Materialized views for the respective source should be loaded. Follow below steps for loading data into star schemas:

Dimensions Load

Dimensions are completely independent objects. Dimensions can be loaded until the time data is synchronized into the replication schema. Follow the steps below to enable all dimensions.
  1. Log in to the Oracle Utilities Analytics Warehouse Administration Tool.
  2. Click Job Configuration in the left panel under ETL Configuration.
  3. In the Job Configuration page, click Enable Jobs.
  4. Select the appropriate Source Product and Instance Number.

  5. In the Job Type field, select Dimension Jobs, and then click Enable Jobs.

    Enable Jobs window showing three dropdown menus for the user to indicate a source product, an instance number, and a job type. Enable Jobs, and Close buttons appear on the top of the window.

Now all dimension jobs for the selected context are enabled. The scheduler agent B1_RUN_ALL is also configured. Therefore, dimension jobs will be triggered by the scheduler agent automatically.

Navigate to the Operator tab and monitor the execution status. You can also monitor the execution of jobs in B1_JOBS_VW in the metadata schema. Wait for all dimensions to load completely. Except for static one-time load dimensions, all other dimensions should be loaded until the time data synced into the replication schema. Use the Oracle Utilities Analytics Warehouse Installation and Configuration Checklist to validate the loading of dimensions into the target data warehouse.

Note:

Although the latest Analytics Warehouse Installation and Configuration Checklist is for version 2.7.0.2 of the product, the steps still apply to version 2.8.0.2.

Facts Load

After all dimensions are loaded successfully, enable all fact ETL jobs by following these steps:
  1. Log in to the Oracle Utilities Analytics Warehouse Administration Tool.
  2. Click Job Configuration in the left panel under ETL Configuration.
  3. In the Job Configuration page, click Enable Jobs.
  4. Select the appropriate Source Product and Instance Number.

  5. In the Job Type field, select Dimension and Facts Jobs, and then click Enable Jobs.

    Enable Jobs window showing three dropdown menus for the user to indicate a source product, an instance number, and a job type. Enable Jobs, and Close buttons appear on the top of the window.

Now all fact ETL jobs are enabled. Scheduling the B1_RUN_ALL job will trigger these fact ETL jobs automation to load their respective target fact table. Navigate to the Oracle Data Integrator→ Operator tab and monitor the execution status. You can also monitor the execution of jobs in B1_JOBS_VW in the metadata schema. Wait for all facts to load completely.

Materialized Views (MV) Load

Follow the same steps in Facts Load above to enable materialized views for the configured source product, and make sure that all required materialized views are created. Except for Oracle Utilities Network Management System, all other source products contain materialized views.

Enable Jobs window showing three drop-down menus for the user to indicate a source product, an instance number, and a job type. Enable Jobs, and Close buttons appear on the top of the window.