Rebinding a View

A view depends on one or more underlying sources, and the view is considered bound to those underlying sources. A view can be bound to tabular data or a procedure. Rebinding is useful when:

•

You create a view with its sources and later decide to rebind the view to different sources.

•

An execution error has occurred for a view because a source with which the view was initially bound does not exist any more.

To rebind a view to a different source

1.

Open the view.

2.

Click the Show Rebind Panel button on the Studio editor toolbar.

The Rebind panel opens in the lower part of the view editor panel and displays the dependencies as determined the last time it was saved.

If a view has never been saved, the rebind window is empty.

3.

In the Rebind panel, select the source from the list in the left pane.

4.

Click the Rebind button.

The Rebind window appears, displaying the resources available for binding.

5.

In the Rebind window, specify the source with which you want to rebind the view, and click OK.

6.

Save the view.

If you modify the view or its dependencies, the binding is automatically updated when you save the view, and the Rebind panel reflects the change. For example, if your view has a data source dependency named ds_orders, and you rename it ds_orders_renamed and save the view, the Rebind panel lists the dependency as ds_orders_renamed.

For details on a view’s lineage and dependencies, see Displaying the Lineage of a View.