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 Enterprise Edition, see Editing Views Created in Oracle BI EE.

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 Oracle BI EE. See the documentation in Oracle BI EE for assistance. Then insert the updated view into Smart View.

Note:

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