Editing Views that were Created in View Designer

Note:

This topic is about editing views that were created in the View Designer in Oracle Smart View for Office. If you are working with views that were created in Oracle Business Intelligence Answers, see Editing Views Created in BI Answers.

When working with views created in the View Designer in Smart View, you can edit the views using either of the following methods:

• Load the view for editing into View Designer in Smart View, as described in Launching the View Designer or About Editing Views Created in View Designer.

  You can edit the layout of the view (for example, add or remove columns) or modify the filters. See the following topics for information on editing views in Smart View:

  • Defining the View Layout

  • Defining the Filter Expression for Views in View Designer

• Open the analysis in BI Answers. See the documentation in BI Answers for assistance. Then insert the updated view into Smart View.

  Note:

  Once a view is created in View Designer and then edited in BI Answers, Oracle recommends that you only edit it thereafter in BI Answers. You should not use Smart View to edit the view. See What Can and Cannot Be Edited for guidelines.