IBM Support

Unable to perform security functions: TM1 Server "Security", "Clients/Groups" menu option is grayed out or missing

Troubleshooting


Problem

This issue occurs despite the connected user being part of the ADMIN group.
In TM1 Architect or TM1 Perspectives Server Explorer, Server 'Security', 'Clients/Groups' menu option is missing.
It is not possible to edit or create any objects (cube, dimension, process, rule, and so on)

Cause

Misplaced or missing tm1p8.lic file (license file)
An antivirus or insufficient permissions might prevent the TM1 installer to access the "C:\ProgramData" directory

Resolving The Problem

On a Windows client machine, the TM1 Perspectives license file (tm1p8.lic) must be present in "C:\ProgramData\Applix\TM1" folder (as of TM1 version 10.1.1).

This directory must also contain the default tm1p.ini
When a user launches Architect or Perspectives for the first time, "tm1p.ini" is created for that user, and placed into user's application data directory (in "C:\Users\<username>\AppData\Roaming\Applix\TM1")
In order to work around the issue, the "tm1p8.lic" file can be copied from "C:\Program Files\ibm\cognos\tm1_64\bin64" and pasted into "C:\ProgramData\Applix\TM1"
Here is the content of that file, if tm1p8.lic is not available anywhere. Copy these lines in order to create the file:
DATABASE_TYPE=TM1 PROPRIETARY
CLASS=500
LICENSE=a1cc2e6f8cd73b4b,16699,12897
MAX_USERS=1
EXPIRE_DT=--
LOCATION=
ORGANIZATION=Cognos
LICENSOR=16699
INSTALL_ID=12897
PRODUCT=TM1 Perspectives
OPTION1=Turbo Integrator
OPTION2=SAP BW
OPTION3=Planning Manager
OPTION4=Financial Reporting
Here is also a default tm1p.ini that can be placed into "C:\ProgramData\Applix\TM1":
[TM1]
DataBaseDirectory = ..\samples\tm1\PData
AdminHost =
ConnectLocalAtStartup = F
LocalServerNetworkProtocol = tcp
IntegratedLogin = F
#AllowImportCAMClients = F
#CognosGatewayURI = http:/LocalHost/cognos10/cgi-bin/cognos.cgi
Once these files are present in "C:\ProgramData\Applix\TM1", all missing menus are displayed and available again.

Related Information

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m3p000000PC6lAAG","label":"Planning Analytics-\u003EArchitect"},{"code":"a8m0z0000001i7nAAA","label":"Planning Analytics-\u003EPerspectives"},{"code":"a8m50000000KzIkAAK","label":"Planning Analytics-\u003ESecurity"},{"code":"a8m0z0000001jX3AAI","label":"Planning Analytics-\u003ESecurity-\u003ETM1 User Group and Object"}],"Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Type":"MASTER"}]

Document Information

Modified date:
24 October 2022

UID

swg21469228