The ad hoc view definition that you create in View Designer can be published to the Presentation Catalog in BI Answers after you have inserted it in Smart View. 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 BI EE 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:
Position the cursor within the view that you just created or edited in View Designer.
In the Oracle BI EE ribbon, click the Publish View icon (Figure 57, Save as Default Options, Accessed from the OK Button).
In Save Report, click
next to Catalog Root, and then navigate to the location in the Presentation Catalog where you will save the view.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.
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.
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.