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. Understand the common use cases of extending the Semantic Model using the Sandbox Framework. See Use Cases: Extend the Semantic Model Using the Sandbox Framework.
  2. Optionally, apply system extensions if you had enabled to delay system extensions, but now want to apply the system extensions. See Apply System Extensions.
  3. Manage Your Sandbox. See Manage Your Sandbox.
  4. Prepare Your Sandbox. See Prepare Your Sandbox.
  5. Add Security Configurations. See Add Security Configurations.
  6. Prepare Your Model. See Prepare Your Model.
  7. Integrate Your Sandbox. See Integrate Your Sandbox.
  8. If required, generate and download the sandbox report. See Generate and Download the Sandbox Report.
  9. In Oracle Analytics Cloud associated with your Oracle Fusion Data Intelligence instance, verify if the changes are reflected in the subject area.
  10. Move your customizations to another environment. See Move Your Customizations to Another Environment.