1. Working with Oracle Smart View for Office
  2. Smart View and Oracle Analytics Cloud
  3. Working with Views Using the View Designer
  4. Publishing Views

Publishing Views

The ad hoc view definition that you create in View Designer can be published to the Oracle BI Presentation Catalog in Oracle Analytics Cloud after you have inserted it in Oracle Smart View for Office. When you publish an ad hoc view, a new analysis in Oracle Analytics Cloud is created with the default views of compound view and title view, along with the applicable user-created view.

When publishing a view that you were editing, you have the option of overwriting the view in the Oracle BI Presentation Catalog, or specifying a new name for the view and publishing the edited version, keeping two versions of the view in Oracle Analytics Cloud.

To publish a view to the Oracle BI Presentation Catalog:

  1. Position the cursor within the view that you just created or edited in View Designer.
  2. In the Oracle Analytics Cloud ribbon, click the Publish View icon (Publishing Views).

    Figure 27-22 Publish View Icon


    The Publish View icon.
  3. In Save Report, click Browse button in Save Report dialog next to Catalog Root, and then navigate to the location in the Oracle BI Presentation Catalog where you will save the view.
  4. In Analysis Name, provide a name.

    If you are publishing an edited view, you have the option of overwriting the view you edited by providing the same name, or providing a new name and keeping the original version of the view intact.

  5. Click Save.

    The default naming convention is applied to the components of the view that is saved; for example, Table 1, Pivot Table 1, Chart 1, and so on.

Example 27-1 Notes

  • If you are publishing a view that was created and then edited in Smart View, you may overwrite it.

  • An error message is displayed if you attempt to overwrite an existing view in the Oracle BI Presentation Catalog if the view was created in Oracle Analytics Cloud.

  • To view the changes made in Oracle Analytics Cloud, you must re-insert the view.

  • Once published, you may make changes to the view as follows:

    • If the view was created in Oracle Analytics Cloud, then use Oracle Analytics Cloud.

    • If the view was created in Smart View, you may edit it either in Smart View or Oracle Analytics Cloud.

  • You may refresh the data in views created in View Designer.

    Ad hoc views created in View Designer remain as a snapshot and will not be kept in sync with the analysis published to the catalog.

  • Changes made to the view in Oracle Analytics Cloud will not be reflected into the ad hoc view that you rendered in Excel. You must reinsert the view from the catalog tree into a new sheet in Smart View in order to view the changes that were made in Oracle Analytics Cloud.