Sunday, 21 October 2012

Prerequisites to a working FM


Cognos Framework Manager (FM) is a windows based client application for designing the cognos  data  model. After you have installed it, and before you start modelling your data with FM, you will need the following things configured.

1. Connectivity to COGNOS Server

Try to reach out the COGNOS SERVER, use Telnet on command line. If you see a black screen after executing these commands individually, you are good to go to next step.

Telnet  <Cognos-server-name> 80
Tenet  <Cognos-server-name> 9300

You can also use a browser to test this, people usually avoid browser to avoid browser settings causing issues. Try the below links.

http://<Cognos-server>:80/ibmcognos/cgi-bin/cognosisapi.dll
http://<Cognos-server>:9300/p2pd/servlet/dispatch

If your tests fail, you will have to contact your system administration team to check the firewall and open ports (80 and 9300) between your computer and cognos server.

2. Connectivity to Database Server

        Check if the database server is reachable, use ping command. Install respective    database client and make a connection to the server using client.For example, if your database is Teradata, install Teradata SQL assistant on your machine, and create a DSN entry in the ODBC list.

3.  Cognos configuration Environment Settings

Open the Cognos Configuration on your client machine. In the Environment update the Gateway URI and Diapatcher URI, just replace localhost to your <Cognos-server> and cognos.cgi (Gateway URI) to cognosisapi.dll




                 
                     If you have questions or suggestions, do comment.