Oracle Customer Engineering & Advocacy Lab (CEAL) Blog covers Oracle Analytics Cloud, Oracle Analytics Server and...

Add a Fact using Semantic Model Extensions

Krishna Prasad Kotti
Senior Member of Technical Staff

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:

  • Launch the Fusion Analytics Warehouse Console and click the Semantic Model Extensions tile.
  • Click Create Branch.
  • Click Add Step and select Add a Fact.



  • Enter the step name and description (Optional).
  • Select the target subject area.



  • Click Next.


  • Select the schema name, object name, and fact name.


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







  • Select the fact and key options:
    • Select Fact – This column is the metric that is available for consumption.
    • Use for Key – This column is used to join with other dimensions.
  • Click the display name to change it to meet your organization’s standards



  • Create columns (Optional).
    • You have the option of defining derived columns.



  • Specify joins and join types.
    • You have the option to skip or specify the joins to the existing dimensions.
    • Join types can be Inner, Left Outer, Right Outer, and Full Outer.
    • Choose Dimension table and dimension key columns.



Note: - The system checks for the Join Key Column data types and displays the following warning message that you can ignore or address it:



  • Select the aggregation rules and add new measures.


  • You can create metrics with the following level-based measures:
    • Time – Balanced Aggregation
    • Hierarchy Level-Based Aggregation