Mittwoch, 19. August 2009

IBM Cognos TM1 quick integration guide for Cognos 8.4 BI

Currently as of Version 9.4.1x of IBM Cognos TM1 the documentation
for using CAM Security in TM1 is unfortunately incomplete and /or misleading.
Therefore I decided to write you a quick integration help.

  1. Install and configure IBM Cognos 8.4 on your system.

  2. Install IBM Cognos TM1.

  3. Install C8_TM1_Portlets_win32_8.4.28.4 to your Cognos 8.4 Directory

IBM Cognos Configuration

  1. Turn anonymous access "off"


  2. Add the TM1 server name to the valid domain list (CAF)

  3. Enable the share of session information for IBM Cognos 8


  4. remember your internal dispatcher URI and gateway URI

TM1

  1. Locate your TM1 Instance which you want to get work with IBM CAM Security (for example (\TM1\Custom\TM1Data\PlanSamp)

  2. Locate and open the file tm1s.cfg

  3. Add the following lines (comment existing entries out):
    ServerCAMURI=your internal dispatcher URI
    dispatchClientCAMURI=your IBM Cognos 8 Gateway URI
    ClientPingCAMPassport=900
    CAMPortalVariableFile = portal\variables_TM1.xml
  4. Change the IntegratedSecurityMode to 4

  5. (IBM documentation says you should change it to 2 but thats wrong!)

  6. Locate and open the variables_TM1.xml file

  7. (can be usually found within your_cognos_8_installation_directory\templates\ps\portal)

    Add the following lines (comment existing - similar - entries out)

    <urls>
    <url>http://your_tm1_server/TM1Web/TM1WebLoginHandler.aspx</url>
    <url>http://your_tm1_server/TM1Web/TM1WebMain.aspx</url>
    </urls>


  8. Restart your TM1 Server and test the login.

  9. You shoud be able to login by Web and with Architect.
    Attention: You may need to assign appropiate rights to administer the server.
    You can do this by changing the parameter IntegratedSecurityMode back to its default (1) and assigning appropiate rights in Architect. (Syntax for the username is namespace_name\username)



If I missed something let me know!

Hv fun!

1 Kommentar: