Publishing Views

The ad hoc view definition that you create in View Designer can be published to the Presentation Catalog in Oracle Business Intelligence Answers after you have inserted it in Oracle Smart View for Office. When you publish an ad hoc view, a new analysis in BI Answers 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 Business Intelligence Enterprise Edition catalog, or specifying a new name for the view and publishing the edited version, keeping two versions of the view in BI Answers.

To publish a view to the Oracle BI EE 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 20-1).

    Figure 19-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 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 19-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 Presentation Catalog if the view was created in BI Answers.

  • Once published, you may make changes to the view in as follows: To view the changes made in BI Answers, you must re-insert the view.

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

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

  • 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 BI Answers will not be reflected into the ad hoc view that you rendered in Excel. You must reinsert the view from the Presentation Catalog into a new sheet in Smart View in order to view the changes that were made in BI Answers.