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:
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 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.