1. Configuring Applications
  2. Import and Use Sample Reports in Oracle Analytical Cloud

Import and Use Sample Reports in Oracle Analytical Cloud

You can import the sample reports using the sample data model OFSC_DataModel_Snapshot.bar file in Oracle Analytical Cloud.

Important: This information only applies to Oracle Field Service environments. You can verify whether you've Oracle Field Service or Oracle Fusion Field Service, by signing in and checking on the About page.
  1. Download the sample data model,OFSC_DataModel_Snapshot.bar file.
  2. Open the console in Oracle Analytical Cloud environment and select Service Administration, and click Manage Snapshots.
    A new form opens.
  3. Choose the downloaded file data_model.bar. Type Admin123 in the password field and click OK.
  4. Click manage snapshot in the right corner of the newly uploaded data model.
  5. Select Restore from the drop-down list.
  6. Select Catalog and Data Model in the Restore Snapshot form and click Restore.
    A warning message is displayed. Click Yes.
  7. Click Page menu on the Home Page, and select Open Data Modeler.
  8. Click Lock to Edit on the right corner for updating the modeler.
  9. From the Database menu in the left pane, click Actions, then click Create View.
  10. In the View editor, specify the name of the view - ACTIVITY_TYPE
  11. From the SQL Query tab, paste the below SQL query for the source view. 
    SELECTDISTINCT
DEMO_TYPE_LIST.ACTIVITY_GROUP,
TO_NUMBER(DEMO_TYPE_LIST.TYPE_ID) ASTYPE_ID,
DEMO_TYPE_LIST.TYPE_LABEL,
DEMO_TYPE_LIST.TYPE_LANG,
DEMO_TYPE_LIST.TYPE_NAME,
DEMO_TYPE_LIST.TYPE_TEXT
FROM
DEMO_TYPE_LIST
WHERE
DEMO_TYPE_LIST.TYPE_NAME= 'activity'
  12. Click Save and Close.
  13. Create another view with Name - PROVIDER_TYPE by following the above steps. From the SQL Query tab, paste the below SQL query for the source view. 
    SELECTDISTINCT
  DEMO_TYPE_LIST.ACTIVITY_GROUP,
   TO_NUMBER(DEMO_TYPE_LIST.TYPE_ID) ASTYPE_ID,
  DEMO_TYPE_LIST.TYPE_LABEL,
  DEMO_TYPE_LIST.TYPE_LANG,
  DEMO_TYPE_LIST.TYPE_NAME,
  DEMO_TYPE_LIST.TYPE_TEXT
 FROM
  DEMO_TYPE_LIST
 WHERE
  DEMO_TYPE_LIST.TYPE_NAME= 'provider'
  14. Click Publish model to save the changes permanently.
  15. Here you can see all the fact tables and dimension tables of the sample data model.
  16. Go to Catalog and choose the OFSC-DEMO folder to see all the sample reports created with the data model.