Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Fusion Analytics Tech Tips : Custom Case Study PVO using Data Augmentation and Semantic Modelling
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:
- Prerequisite for custom public view objects
- Understanding the source data
- Data Augmentation process
- Data modeling tweaks for a star schema
- Model using Semantic Model Extension
- Create branch
- Create subject area for Quotes
- Create dimensions
- Extend dimension
- Create fact
- Modify subject area
- Re-use the Quotes subject area to create Consumption subject area
- Add dimensions in the Consumption subject area
- Add facts in the Consumption subject area
- Create custom subject area referencing the prebuilt custom Quotes subject area
- Create missing dimensions in the Consumer subject area
- Publish the model
- Validate the model
- Deploy the model
Each of these steps are explained and illustrated in the attached case study and we hope you find the information beneficial.
2