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 copy the steps from the main branch, edit them directly, and later merge them with the main branch. However, you must ensure not to perform two or multiple levels of copies. For example, you must not copy steps from the main branch to another branch, then copy the steps over to yet another branch, and then merge the second branch with the main branch.
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.
- 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.
From release Platform 23.R4 onwards, Oracle Fusion Analytics Warehouse periodically evaluates the customizations and sends notifications to the users with Modeler Administrator and Modeler privileges to correct errors and warnings in branches and steps as soon as possible to prevent errors during patching. If these errors aren't fixed and a patch is initiated (or a mandatory patch is auto-applied), then patching may encounter issues. In that case, customizations that haven't been merged to the main branch are removed and the factory semantic model is upgraded. You must reapply the applicable customizations after the patching is complete.