1 Sample Data Deployment Guide
This document provides instructions on how to deploy the Oracle Healthcare Foundation (OHF) sample data files. The sample data files populate the Healthcare Data Mart (HCD) with sample data for the Oracle Healthcare Foundation Dashboards or for other analytics uses.
- Download the Oracle Healthcare Foundation Samples file
OHFSSA 7.2 Samples.zip
from My Oracle Support (MOS) (https://support.oracle.com/
) under the patch 24929753. - Copy the file to a preferred drive on a Windows machine and extract the contents.
The following files will be extracted:
ohf_dims_insert.sql
ohf_facts_001_insert.sql
ohf_facts_003_insert.sql
ohf_facts_004_insert.sql
ohf_facts_005_insert.sql
ohf_facts_006_insert.sql
ohf_facts_007_insert.sql
ohf_facts_008_insert.sql
ohf_helper_dims_insert.sql
ohf_master_insert.sql
- To insert the sample data into the Healthcare Data Mart (HCD), connect to the HCD schema through SQLPlus or SQLDeveloper.
- Execute the
ohf_master_insert.sql
script available under /data. This inserts data into all HCD schema dimensions and facts used by the Oracle Healthcare Foundation Reports.The Oracle Healthcare Foundation sample data is now installed.
You can access the sample reports and dashboards from the Oracle Analytics Server Analytics page (http://obiee host name:port
number/analytics
) under Dashboards, in the
Oracle Healthcare Foundation group.