IBM Support

How to configure the pmhub for IBM Cognos Analysis for Excel

Technote (troubleshooting)


Problem(Abstract)

IBM Cognos Analysis for Excel does not connect to the TM1 Server. It appears the following error message:

The Website can not display the page

Cause

The URL under http://servername:portnummer/pmhub/pm/admin does not match to the URL entries in IBM Cognos Configuration.

Environment

Linux, Unix and Windows

Resolving the problem

Please open a browser and go to the following page

http://servername:portnummer/pmhub/pm/admin .

The following entries have to match to the URLs in the IBM Cognos Configuration. The URL entries are case sensitive.

CAMBIDomain - It should be set to the domain of the host the TM1 Application Server runs on. Example: Assume the TM1 Application Server URL is http://cognosgw.mydomain.company.com:9510, then the CAMBIDomain should be set to .mydomain.company.dom (mind the leading dot).  (e.g. .ibm.com )  

CAMBIURL - This is the Dispatcher URI for external applications of a  single IBM Cognos BI Dispatcher to which the PM-Hub will send requests to validate the BI authentication.
(e.g.: https://cognos.office:9012/p2pd/servlet/dipatch )

CAMGatewayURL - specify the URL of the IBM Cognos BI selected for PM-Hub entry point. Ensure using a consistent naming scheme like FQDN or  NetBIOS only. The URL specified here will be used when PM-Hub generates  re-directs for the BI authentication to be called.
(e.g. https://cognos.office:9010/cognos10/cgi-bin/cognos.cgi )

Document information

More support for: Cognos Business Intelligence
Cognos Analysis for Microsoft Excel

Software version: 10.2, 10.2.1, 10.2.2

Operating system(s): Linux, Windows

Software edition: All Editions

Reference #: 1696448

Modified date: 23 January 2017


Translate this page: