IBM Support

Advanced Rules Editor not working. No error, just the classic editor opens instead.

Troubleshooting


Problem

Advanced Rules Editor not working. No error, just the classic editor opens instead.

Resolving The Problem

Important warning before applying solution :
Advanced Rules Editor is no more supported since 10.1.1
- Supported environments ending with Cognos TM1 10.1.1 :
http://www-01.ibm.com/support/docview.wss?uid=swg27027501
Cognos is ending support for the following environments and/or features in an upcoming release.
Components Advanced Rules Editor in TM1 Architect and TM1 Perspectives
- Deprecated and discontinued functionality in IBM Cognos TM1
Advanced Rules Editor in TM1 Architect and TM1 perspectives is no longer actively supported as of TM1 10.2 (note: capability is available "as is" in TM1 10.2)
http://www-01.ibm.com/support/docview.wss?uid=swg21661245

Solution :

1) Verify that parameter AdvancedRulesEditor = T has been correctly set in the right tm1p.ini, which should resides in "C:\Users\<username>\AppData\Roaming\Applix\TM1"

2) Verify that the following component is installed :
Microsoft Visual C++ 2005 SP1 Redistributable Package (x64 or x32 depending on the OS version)

3) Verify that the following component is installed :
Microsoft .NET 3.5 SP1 Framework

4) Run the following MSDOS command from directory "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727" :
regasm.exe "<TM1_install_root>\bin\TM1RuleEditor.dll"

5) If point 4 does not work, then retry with the /codebase parameter :
regasm.exe /codebase "<TM1_install_root>\bin\TM1RuleEditor.dll"

6) If nothing works, take a look at the installation log file in <TM1_install_root>\instlog. Its name should be isconfig-PLANANALYTICS-date_time.log or isconfig-TM1CLIENT-date_time.log :
verify that the registration of TM1RuleEditor.dll was OK.

7) Check wether this problem occurs on both Architect and Perspectives. If the problem occurs only with Perspectives then there must be some problem related to Excel installation. If so, then contact IBM Cognos Customer Support.

Important warning :
Advanced Rules Editor is no more supported since 10.1.1

- Supported environments ending with Cognos TM1 10.1.1 :
http://www-01.ibm.com/support/docview.wss?uid=swg27027501

Cognos is ending support for the following environments and/or features in an upcoming release.
Components Advanced Rules Editor in TM1 Architect and TM1 Perspectives

- Deprecated and discontinued functionality in IBM Cognos TM1
Advanced Rules Editor in TM1 Architect and TM1 perspectives is no longer actively supported as of TM1 10.2 (note: capability is available "as is" in TM1 10.2)

http://www-01.ibm.com/support/docview.wss?uid=swg21661245

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Perspectives","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.2;10.1.0","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21615331