About Semantic Model Customization

You can customize the semantic model to extend it for your business requirements. You extend the semantic model to make the data that you moved into the warehouse more useful for reporting.

You customize your semantic model in the non-production environments such as development or test by creating branches and adding steps to those branches. You use a branch or version to publish your changes to the model. You can apply the model from the branch to a local service instance for testing. When the changes are correct, you can merge that branch with the main branch. You can merge multiple branches with the main branch over time. When you have a set of changes finalized, you can version the main branch and promote that branch to the production environment. After promoting the customizations to the production environment, you can’t directly add further customizations to the semantic model in the production environment.

You can customize the model by extending ready-to-use dimensions with additional attributes from another data source, by adding a fact to an existing subject area, and by reorganizing the ready-to-use subject areas to create a new subject area to name a few.

The semantic model consists of these components:
  • Oracle Content: This is the base model provided by Oracle. Your customizations are layered on this.
  • System Extensions: Your descriptive flexfield and data augmentation changes are available in this component. See View Activity History of Semantic Model Extensions to know about the scenarios in which Oracle Fusion Analytics Warehouse applies the system extensions.
  • User Extensions: Your customization branches and versions are available in this component.
  • Security Configurations: You can secure the objects of all the other components against the application roles in this component.