Guidelines for Editing Views Created in View Designer

  • Only views created and inserted from the View Designer in Oracle Smart View for Office can be edited using the View Designer.

  • Views created in Smart View may also be edited in Oracle Analytics Cloud. However, views created in Smart View and then further edited in Oracle Analytics Cloud cannot afterward be edited in View Designer.

    Note:

    To edit views created in Oracle Analytics Cloud, use the Oracle Analytics Cloud application (see Editing an Analysis in Oracle Analytics Cloud).

  • When you use View Designer to edit a table view or pivot table view, Smart View performs a replace operation, effectively replacing the view on the sheet with the newly-edited view; that is, the table on the sheet is deleted and a new table is inserted. If the new table has more rows or columns than the previous table, any content or formulas that you may have added to the sheet prior to editing the view in View Designer may be removed and you will need to add them again.