Publish Changes to Your Semantic Model

As you update a semantic model, you make changes that you can save or discard. You publish a model to save the changes permanently and make the data available for use in reports. The published semantic model displays as a subject area.

Tip:

Although changes to the semantic model are saved as you work, they are saved in the browser session only. The changes aren’t truly saved until you publish the model.

When you publish a semantic model, it is validated automatically. Any validation errors appear in the bottom of the right pane. If you see validation errors, fix them and then try to publish the semantic model again.

After making changes to your semantic model, you can perform these actions using the menus in the upper-right corner:

  • Publish and Unlock — Verifies that the model is valid, saves the changes, and publishes the model for use with reports. The model is unlocked for other users.
  • Publish and Keep Lock — Verifies that the model is valid, saves the changes, and publishes the model for use with reports. The lock is retained for further edits.
  • Unlock — Removes the lock on the model so that other users can update it. Your unpublished changes to the model are discarded.
  • Revert — Returns the model to its previously published state. Your unpublished changes to the model are discarded, but the model remains locked.
  • Clear—Permanently deletes all objects in the model and removes them from any reports that are based on the model’s subject area.

You can also click Undo and Redo in the upper right corner to revert or reapply individual changes.

Tip:

You don’t need to publish the model to save database changes. Changes made to database views and other source database objects are saved to the database when you complete the action, not to the semantic model. For database changes, Undo and Redo aren't available.

After publishing your model it takes up to two minutes for changes to the semantic model to reflect in reports and dashboards. To see changes immediately, open the report, click Refresh, and then Reload Server Metadata.

Oracle Analytics Cloud takes a snapshot when you or someone else publishes changes to the semantic model. If you’re having some problems with the latest semantic model, you can ask your administrator to restore an earlier version.