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.
To publish a view to the Oracle BI EE Presentation Catalog:
Position the cursor within the view that you just created using View Designer.
In Save Report, click
next to Catalog Root, and then navigate to the location in the Presentation Catalog where you will save the view.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.
.An error message is displayed if you attempt to overwrite an existing view in the Presentation Catalog.
Once published, you may make changes to the view in BI Answers using the report editing wizard. You cannot edit the view in Smart View. To view the changes made in BI Answers, you must re-insert the view.
You may refresh only 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.