How to change hardcoding URI connection in CAFE

Technote (troubleshooting)


Problem(Abstract)

Usually, during an update of Cognos BI version, server name change, so we need to change URI for Excel CAFE.

Cause

First URI used for connection is hardcoding in Excel CAFE document.

Environment

Excel documents

Resolving the problem


1. Open MS Excel
2. Click on the 'IBM Cognos' button in the IBM Cognos toolbar
3. Cancel the log on screen
4. In the CAfE options add the new System-Gateway-URI
5. Place your cursor on the first Excel cell (upper-left) of the current sheet.
6. Double click on this cell
>> A window opens ... "Select Pack"
7. Select the name of the new connection created at the step 4
8. Once validated, CAFE menu appears.
9. Remove your old URI in CAFE options
10. Save your document


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Analysis for Microsoft Excel
Analysis for Excel

Software version:

8.4.1, 10.1, 10.1.1

Operating system(s):

Windows

Reference #:

1643593

Modified date:

2013-08-16

Translate my page

Machine Translation

Content navigation