Page 1 of 1
[Solved] How to Enable Advanced Rules Editor in TM1 10.1?
Posted: Fri Sep 14, 2012 12:11 pm
by Anuradha
Hi,
I have TM1 10.1 on Win 7 with .NETFRAMEWORK 3.5 SP1.
I am trying to get the Advanced Rules Editor by updating TM1P.ini file as T for AdvancedRulesEditor. I have restarted the services and still cannot get the AdvancedRulesEditor option. I have right click the Sales cube and chose create rule option and it still shows basic editor.
tm1p.ini file location path:-
C:\Program Files\ibm\cognos\tm1\bin\tm1p.ini
Am I missing out something on 10.1? Please help me with this.
Thanks,
Anu
Re: How to Enable Advanced Rules Editor in TM1 10.1?
Posted: Fri Sep 14, 2012 12:15 pm
by charan
You must stop the services and update it, save it and restart the services(TM1 Admin services).
Try with this.
Re: How to Enable Advanced Rules Editor in TM1 10.1?
Posted: Fri Sep 14, 2012 12:27 pm
by tomok
Anuradha wrote:Hi,
I have TM1 10.1 on Win 7 with .NETFRAMEWORK 3.5 SP1.
I am trying to get the Advanced Rules Editor by updating TM1P.ini file as T for AdvancedRulesEditor. I have restarted the services and still cannot get the AdvancedRulesEditor option. I have right click the Sales cube and chose create rule option and it still shows basic editor.
tm1p.ini file location path:-
C:\Program Files\ibm\cognos\tm1\bin\tm1p.ini
Am I missing out something on 10.1? Please help me with this.
Thanks,
Anu
This is a client setting, it has nothing to do with the server. Stopping and restarting the services won't do a thing. Your problem is you changed the wrong tm1p.ini. The one you want to change is in your personal directory for app settings. I don't know what OS you are using but in Windows 7 you would find it in C:\Users\YourUserName\AppData\Roaming\Applix\TM1.
Re: How to Enable Advanced Rules Editor in TM1 10.1?
Posted: Sat Sep 15, 2012 12:00 am
by Alan Kirk
tomok wrote:Anuradha wrote:Hi,
I have TM1 10.1 on Win 7 with .NETFRAMEWORK 3.5 SP1.
I am trying to get the Advanced Rules Editor by updating TM1P.ini file as T for AdvancedRulesEditor. I have restarted the services and still cannot get the AdvancedRulesEditor option. I have right click the Sales cube and chose create rule option and it still shows basic editor.
tm1p.ini file location path:-
C:\Program Files\ibm\cognos\tm1\bin\tm1p.ini
Am I missing out something on 10.1? Please help me with this.
Thanks,
Anu
This is a client setting, it has nothing to do with the server. Stopping and restarting the services won't do a thing. Your problem is you changed the wrong tm1p.ini. The one you want to change is in your personal directory for app settings. I don't know what OS you are using but in Windows 7 you would find it in C:\Users\YourUserName\AppData\Roaming\Applix\TM1.
Just to add to Tomok's quite correct answer, you can get to the relevant application data directory in any Windows version by typing the environment variable
into the address bar of Windows Explorer and pressing Enter. That will take you directly there.
For some reason despite everything else being re-branded as IBM and/or Cognos, the file will indeed be found in a folder which is still named Applix.
I'd be interested to hear whether you get it to load in Windows 7. I have 10.1 on only a single test machine and as I mentioned recently in another thread the advanced rules editor wouldn't launch for me; it flashed a window which then just shrunk down to nothing and vanished. Whether that was an issue specific to that particular machine or whether it's something relating to the Win 7 / 10.1 combination is something that I'm curious about, though since I never use the thing I haven't put a great deal of effort into finding the answer.
Re: How to Enable Advanced Rules Editor in TM1 10.1?
Posted: Sat Sep 15, 2012 11:18 am
by dkleist
I had the same issue with CX10.1 client (Xcelerator) on Win7/Office2010. Advanced editor opens from Architect but fails from the Excel client. Machine has .Net 4 on it and my suspicions (unproven) is that somehow the calls via Excel get mangled because the multiple .Net versions on the machine. Between the slog to figure out root cause and end-of-life for Advanced Rules editor, the client is uninterested in pursuing the matter further.
[Solved] Re: How to Enable Advanced Rules Editor in TM1 10.1
Posted: Mon Sep 17, 2012 5:20 am
by Anuradha
This issue has been successfully resolved. This is what I followed to get to the solution :-
1. I stopped TM1 services. (No need to stop or start services. Please skip this step)
2. Typed %APPDATA% in a browser to get to the relevant application data directory in any Windows version by typing the environment variable
3. It took me to this path location 'C:\Users\admin\AppData\Roaming\Applix\TM1\tm1p.INI'
4. In tm1p.ini file, I have replaced 'F' with 'T' as "AdvancedRulesEditor = T". Save and close the file
5. Restarted the TM1 services. (Please skip this step.)
6. Right clicked a cube and chose the option Create Rule and tada Advanced Rules Editor opened.
Thanks everybody especially tomok and Alan for your timely response and helping me fix this.
Regards,
Anu
Re: [Solved] How to Enable Advanced Rules Editor in TM1 10.1
Posted: Wed Oct 10, 2012 10:16 am
by winoth
Alan Kirk wrote:tomok wrote:Anuradha wrote:Hi,
I have TM1 10.1 on Win 7 with .NETFRAMEWORK 3.5 SP1.
I am trying to get the Advanced Rules Editor by updating TM1P.ini file as T for AdvancedRulesEditor. I have restarted the services and still cannot get the AdvancedRulesEditor option. I have right click the Sales cube and chose create rule option and it still shows basic editor.
tm1p.ini file location path:-
C:\Program Files\ibm\cognos\tm1\bin\tm1p.ini
Am I missing out something on 10.1? Please help me with this.
Thanks,
Anu
This is a client setting, it has nothing to do with the server. Stopping and restarting the services won't do a thing. Your problem is you changed the wrong tm1p.ini. The one you want to change is in your personal directory for app settings. I don't know what OS you are using but in Windows 7 you would find it in C:\Users\YourUserName\AppData\Roaming\Applix\TM1.
Just to add to Tomok's quite correct answer, you can get to the relevant application data directory in any Windows version by typing the environment variable
into the address bar of Windows Explorer and pressing Enter. That will take you directly there.
For some reason despite everything else being re-branded as IBM and/or Cognos, the file will indeed be found in a folder which is still named Applix.
I'd be interested to hear whether you get it to load in Windows 7. I have 10.1 on only a single test machine and as I mentioned recently in another thread the advanced rules editor wouldn't launch for me; it flashed a window which then just shrunk down to nothing and vanished. Whether that was an issue specific to that particular machine or whether it's something relating to the Win 7 / 10.1 combination is something that I'm curious about, though since I never use the thing I haven't put a great deal of effort into finding the answer.
Hi Alan, Were you able to get it to work? Running TM1 10.1 FP1 client on Windows Server 2008, I am facing the same issue. So far, I have installed in two machines and it does not work in both.
Thanks.
Re: [Solved] How to Enable Advanced Rules Editor in TM1 10.1
Posted: Wed Oct 10, 2012 8:00 pm
by Alan Kirk
winoth wrote:
Hi Alan, Were you able to get it to work? Running TM1 10.1 FP1 client on Windows Server 2008, I am facing the same issue. So far, I have installed in two machines and it does not work in both.
No, but I haven't tried all that hard because it doesn't matter to me.
If you're sure that you have the correct .Net frameworks installed it might be time to raise a Service Request with IBM support.
Re: [Solved] How to Enable Advanced Rules Editor in TM1 10.1
Posted: Sun Jan 05, 2014 7:50 pm
by gbehel
Thanks All,
I was facing this issue myself... could fix it with the replies given in this post
Regards
Gbehel
Re: [Solved] How to Enable Advanced Rules Editor in TM1 10.1?
Posted: Wed May 24, 2017 9:19 pm
by Bishop
And just a quick caveat to that solution - Architect (not the server) must be closed down before making the changes to the tm1p.ini file otherwise the file changes won't be retained.