Skip to content

Ahmed Lashin

Cognos, Business Intelligence and MORE …

Archive

Archive for March, 2009

In many business cases you may need to have more than one Cognos environment on the same machine (like a development and testing environment or multiple development environments).

The installation is simply the normal Cognos installation. The only note in the installation step is to ensure that each instance has been installed into a different directory. for example

install instance 1 under c:\Program Files\cognos\cognos83dev\
install instance 2 under c:\Program Files\cognos\cognos83tst\

The real work will be in Configuring the second instance to overcome any potential conflict. So, amusing that you already have a running Cognos installation and you need to install another instance of Cognos. Here is how to do this,

1- On the web server ensure that there are separate virtual directories pointing to the corresponding install directory for each instance.

2- In Cognos Configuration under Environment, ensure that no two instances are both set to use the same port number (9300 for the default Tomcat application server) in the Dispatcher URIs for gateway, External Dispatcher URI, Internal Dispatcher URI, Content Manager URIs and Dispatcher URIs for external applications settings. (I used 9301 for the second installation).

3- In Cognos Configuration under Environment -> Logging, ensure that no two instances are both set to use the same Local log server port number ( 9362 was the default port used in the first installation, I used 9363 for the second installation).

4- In Cognos Configuration under Environment -> Cognos 8 service ensure that no two instances are both set to use the same Shutdown port number. ( 9399 was the default port used in the first installation, I used 9398 for the second installation).

5- Ensure that no two instances are pointing to the same content store. In Cognos Configuration under Environment -> Cognos Content database ensure that no two instances are both set to use the same Shutdown port number. ( 1527 was the default port used in the first installation, I used 1528 for the second installation). You will need to change the same port under the Data Access -> Content Manager -> Cognos Content Store.

Note : Make sure any new port assigned are not currently in use. You can run “netstat -a” to list out all the port numbers currently in use.

When I am working in Framework Manager, I always use the Context Explorer to check the relationship between database entities, fact tables and their dimensions in a star schema.  When I moved to Cognos v8.4, I noticed a very annoying problem. The Context Explorer is not saving the settings between sessions. So each time I open the Context Explorer I have to select the view options like Star Schema options and others. I am sure I didn’t have this problem in Cognos v8.3.

So after searching IBM support website, I found that it is a problem and that they have a workaround for it. here is what I found in IBM support website,

In Framework Manager, the level of detail settings (query items, relationships, cardinality, notation) are not saved. Changing these in the Context Explorer will not save these settings for the next session

Change these settings in the Diagram View, and they will be propagated the next time Context Explorer is used.

Steps
8.2:

  1. Open the Diagram View (View > Views > Diagram View)
  2. Set the level of detail, either by right-clicking on the whitespace and selecting Level Of Detail, or go to Diagram > Level Of Detail
  3. Save the project

8.3/8.4:

  1. Open the Diagram View (View > Views > Diagram View)
  2. Go to Diagram > Diagram settings…
  3. Specify the Level of Details
  • Select whether you want these settings to be the default for all new projects (8.4 Only) Click OK and then Save the project