1. User's Guide
  2. Smart View and Oracle BI EE
  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 Business Intelligence Enterprise Edition after you have inserted it in Oracle Smart View for Office. When you publish an ad hoc view, a new analysis in Oracle BI EE 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 BI EE.

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 BI EE ribbon, click the Publish View icon (Figure 25-2).

    Figure 22-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 22-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 BI EE.

  • To view the changes made in Oracle BI EE, you must re-insert the view.

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

    • If the view was created in Oracle BI EE, then use the Oracle BI EE.

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

  • 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 BI EE 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 BI EE.