Fusion Analytics Warehouse (was Oracle Analytics for Applications)
Add a Fact using Semantic Model Extensions
With input from
Balaji Krishnan, Product Management Architect, Analytics Applications
This blog talks about various options and wizard sequence of steps for adding a new fact using the Semantic Model Extensions.
The feature “Add a Fact” has been available with Fusion Analytics Warehouse (was Oracle Analytics for Applications or OAX) version 3.1. It provides you with options to bring in third-party data from external systems to customize and personalize existing subject areas by adding a fact to an existing subject area.
This feature is available only for administrators. For more details on the role(s) needed, review the documentation at https://docs.oracle.com/en/cloud/saas/analytics/administer.html
Follow these steps to add a fact:
Note: - Ensure that you grant select permissions to OAX$OAC for the required objects.
More information is available here:
Load Customization Data to the Autonomous Data Warehouse
Note: - The system checks for the Join Key Column data types and displays the following warning message that you can ignore or address it: