Modeler Role setting for Cognos 8 incase you do not want to give Server Admin rights

Problem : Got new transformer licenses,but need to setup Modeler role in Cognos 8 configuration.Do not want to give System Administrator roles to
modelers and want to restrict access only what they will require.

Error Messages :

TR0164 Data source create problem. CCL-RCI-0002 The Soap server returned a Soap fault.

CM-REQ-4012 you do not have the appropriate permissions to update or delete the object "/Directory/Cognos" or a related object


Solution : Some of the points are from Cognos documentatin,however it is not more specific there in document.


1) Database client software is installed, or available for modelers to install, on the Transformer computers that are used to access IBM Cognos 8 data sources.

2) Modelers must have privileges to create a data source in IBM Cognos Administration.

The good way to do it is create a role as Cognos modeler in Cognos group and assign the roles required as below to it.The individual modeller ids can be
added to group then.

Go to IBM Cognos Configuration.

To enable capabilites select the Administrator Set Properties tab.Add the Modeler group you created and assign just traverse permission here.

Click on Administration and select Set Properties for Data Source Connections.Add the Modeler group and assign read,write,execute and traverse permission here.

Go back to main Capabilites page and select Set Properties for Cognos Viewer.Add the Modeler group and assign execute and traverse permission here.


3) Modelers must have access to a location in which to store the PowerCube after building it.

4) To build PowerCubes on a specific Transformer server, modelers should have FTP privileges to transfer models and execute privileges to build cubes on that server.
Normally its good idea to restrict access as far as possible in server.