Modifying Connections

You can modify connections in two different ways: Modify a private connection or modify the connection information for individual entities within an Office document.

Modify a private connection. You can modify a private connection to change the server, application, or database information for all data providers associated with the connection.

The connection information can be changed whether you are connected or not.

For example, you may be working in a test environment using a private connection. When you are ready to move to a production environment, you change the server information for that private connection to access the new environment.

This procedure is described in Modifying Private Connections.
Modify the connection information for individual entities within a document. You can modify the connection information for individual entities within a document using the Document Contents panel. You can change connections per sheet. Or, in a sheet containing multiple entities, you can change the server connection for one or more of the individual entities.

For example, while connected to Oracle Business Intelligence Enterprise Edition, you may have inserted a compound view containing 10 graphs. Now you would like to pull data from a different Oracle BI EE server for three of the graphs. Using the Document Contents panel, you can modify the connection information s for the each of the three graphs to point to the newOracle BI EE server.

This procedure is described in Modifying Connections within an Office Document.

Note:

When you modify connection information, the new data source that you point to must contain all the dimensions and members of the previous data source. Any missing dimensions or members in the new data source will cause errors upon refresh.