IBM Support

Automatic TM1 CAM user creation when using CAM / BI (non-native) security

Troubleshooting


Problem

Customer uses the Controller feature "FAP" to publish data to a TM1 cube. They would like to use Cognos BI (CAM) authentication, and reduce the workload by automatically creating TM1 users. How can they achieve this?

Symptom

In previous versions of Controller (version 10.1 IF6/10.1.384 and earlier) the following is true:

  • If Controller is configured to use "native" security (e.g. logon as ADM etc.) then TM1 user creation via FAP is automatic
  • If Controller is configured to use "CAM" (Cognos 8 / BI) security (e.g. logon as active directory user etc.) then TM1 user creation via FAP is manual
    • In other words, see separate IBM Technote #1460537.

However, in later versions of Controller, it is possible to automate the TM1 CAM user creation process.

Environment

Controller 10.1 IF7 (10.1.387) or later.

Resolving The Problem

Ensure that BOTH of the following are done:

(1) Ensure that you are using Controller 10.1 IF7 (10.1.387) or later.

  • TIP: To upgrade to Controller 10.1 IF7 (or later IF version) see separate IBM Technote #1504613.

(2) Set the property "automateCAMUsers=true" in the 'FAPService.properties' file

Steps to modify the FAPService.properties file:

  1. Logon to the relevant Controller application server as an administrator
  2. Open the folder "...c10\server\FAP". TIP: By default, this is: C:\Program Files\IBM\cognos\c10\server\FAP
  3. As a precaution, create a backup copy of the file "FAPService.properties"
  4. Open the file "FAPService.properties" inside NOTEPAD.EXE
  5. Add the following line (e.g. at the end of the file): automateCAMUsers=true
  6. Save and close file
  7. Obtain a short period of downtime (no users on the system) and reboot server to ensure that all the changes are registered.
  8. Test.

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21590666

Page Feedback