You can modify connections in two different ways: modify a private connection or modify the connection information for individual entities within an Office document. Additionally, you use the Edit Connection command to modify connections for Financial Reporting images and fully-fomatted reports.
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 for the each of the three graphs to point to the new Oracle BI EE server.
This procedure is described in Modifying Connections within an Office Document.
Modify the connection information for individual Financial Reporting images and fully-formatted reports images in Office documents. Using the Edit Connection command accessed from the Smart View ribbon, you can change the connection information for entities in Excel, Word, and PowerPoint. This is useful when sharing an Office document between departments or when moving from a test to a production environment.
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.