Update a PowerCube Connection in Cognos 8

Update a PowerCube Connection
If a PowerCube has been rebuilt, you can update the connection information without affecting
current users. To do this, you must first update the connection information to the rebuilt PowerCube, and then refresh the report servers to use the rebuilt PowerCube for new connections.
The updated PowerCube will be used for all new sessions referencing that data source. Any user
that has an active session against the data source may have to re-open their session. Old PowerCubes can be removed only after all sessions using that PowerCube have ended.
When you rebuild the cube, we recommend that you use a new name for the PowerCube, such as
including the current date in the new name. You can then store the rebuilt PowerCube in the same location as the old PowerCube. For convenience, Cognos provides the sample script cubeswap.bat or cubeswap.sh that is located in the c8_location/webapps/utilities/cubeSwap directory. You can get more information about the script syntax by running the script without any parameters.
Tip: You can automate this task using the Cognos 8 SDK to hot swap PowerCubes. For more
information, see the SDK Developer Guide.
For information about refreshing report service connections, see

Steps
1. In Cognos Connection, in the upper-right corner, click Launch, Cognos Administration.
2. On the Configuration tab, click Data Source Connections.
3. Click the data source representing the cube you want to update.
4. Click the set properties button for the connection you want to update.
5. Click the Connection tab.
6. Click the edit button for the connection string.
7. Change the file path and name to point to the rebuilt cube.
Tip: To test whether parameters are correct, click Test. If prompted, type a user ID and password
or select a signon, and then click OK.
8. Click Close, and Close again, then click OK, and OK again to return to the data sources page.
9. In the left pane, click Dispatchers and Services.
10. Click the refresh report service connections button .
Any new connections to the PowerCube will use the updated cube.

Refresh Report Service Connections

If a PowerCube has been rebuilt, you can update the connection information without affecting
current users. To do this, you must first update the connection information to the rebuilt PowerCube, and then refresh the report servers to use the rebuilt PowerCube for new connections.
Steps
1. Start Cognos Connection.
2. In the upper-right corner, click Launch, Cognos Administration.
3. On the Status tab, click System.
4. With all servers displayed, click the check box for the servers you want, and from the Toolbar
actions menu, click Refresh report service connections.

Tip: You can also do this from the Actions menu next to System, servers, and dispatchers. You
can also click the Configuration tab, and then click Dispatchers and Services, and then click
the Refresh Report Service Connections - Configuration button.
5. When the View the results page appears, ensure that the operation has been successful and then click Close.