Extend the Semantic Model Using the Sandbox Framework

The Sandbox framework enhances the development process with its intuitive graphical modeling capabilities. It enhances the user experience by visually organizing related elements within each logical star and subject area. The logical task organization and minimal steps make customization easy and efficient.

The Sandbox framework streamlines development by allowing changes to be made without requiring chronological order, eliminating the need to wait for compilation until all modifications are complete. This framework promotes greater consistency in the semantic model, supporting adherence to best practices.

Multiple users can work concurrently in separate or the same customization sandboxes. Limit the customizations within each sandbox to a single logical star and corresponding subject area. To ensure your work incorporates the latest changes, compare the update date of your sandbox with the main sandbox. If your sandbox was updated before the main sandbox, review common artifacts that may have been amended and published prior to your changes. If common artifacts have been modified, create a new customization sandbox, transfer your changes, and then delete the old sandbox to avoid conflicts before merging to the main sandbox. Publish only one sandbox at a time. Publishing a sandbox ensures that unchanged components remain, while any modifications within the sandbox overwrite their corresponding versions in the main published sandbox. Only retain the in-use sandboxes. Delete the sandboxes that you used for testing and aren't in use any longer. Maintaining additional unused sandboxes degrades performance of the system.

A typical workflow to create extensions involves these:
  1. Create a sandbox.
  2. Select Perform Action and then select Create or Manage a Star .
  3. Make changes as required (the changes are done to the logical model).
  4. Select Perform Action and then select Manage Subject Areas.
  5. Incorporate logical changes in the desired subject areas.
  6. Go back to the Semantic Model Extensions page, select User Extensions, select Apply Changes to validate the semantic model's integrity before publishing.
  7. Merge to the main sandbox or publish your sandbox.
  8. Secure the objects. See Add Security Configurations.
  9. Validate the model.
  10. Publish the model.
  11. In Oracle Analytics Cloud associated with your Oracle Fusion Data Intelligence instance, verify if the changes are reflected in the subject area.

Topics: