With inputs from

  • Manjunath Subramanian ,Senior Principal Product Manager
  • Navnit Mishra , Consulting Member Of Technical Staff, Customer Excellence, Analytics
  • Hiteshkumar Patel ,Senior Principal Product Manager

Related blog : Creating a custom subject area on external data (non-fusion data)

What you’ll learn

The document describes how to extract data from Fusion through data augmentation in FAW and then use it to build new subject areas .

If your use case is 

The basic procedure

The steps you’ll need to take include:

  1. Prerequisite for custom public view objects
  2. Understanding the source data 
  3. Data Augmentation process
  4. Data modeling tweaks for a star schema
  5. Model using Semantic Model Extension
    1. Create branch
    2. Create subject area for Quotes
    3. Create dimensions
    4. Extend dimension
    5. Create fact
    6. Modify subject area
    7. Re-use the Quotes subject area to create Consumption subject area
    8. Add dimensions in the Consumption subject area
    9. Add facts in the Consumption subject area
    10. Create custom subject area referencing the prebuilt custom Quotes subject area
    11. Create missing dimensions in the Consumer subject area
  6. Publish the model
  7. Validate the model
  8. Deploy the model

Each of these steps are explained and illustrated in the case study, and we hope you find the information beneficial.

If you have any questions about this procedure or your configuration, please feel free to contact us. The Oracle Analytics team is always happy to lend a hand.

Schedule a meeting today to talk to the Oracle Analytics product team and learn more about how you can extend Oracle Fusion Analytics Warehouse to include data from external sources.