Questions for Code editor (TI/Rule)

Post Reply
jimhung777
Posts: 8
Joined: Mon Aug 07, 2017 5:39 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Questions for Code editor (TI/Rule)

Post by jimhung777 » Fri Oct 27, 2017 5:22 am

Hello~
I have no idea what kind of code editor would be easy for everyone to write code and possibly has version control.
The one I am using to write TM1 code is Notepad++.
It's great but I still look for others possible more suitable for me.
Is there any code editor better than Notepad++ ??
Could anyone please kindly recommend me ??

Thanks a lot. :D :D :D

Wim Gielis
MVP
Posts: 1569
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Questions for Code editor (TI/Rule)

Post by Wim Gielis » Fri Oct 27, 2017 6:13 am

In PAW, the TI editor is / will be improved greatly: coloring, function completion, showing the needed arguments of functions, and so on.

Myself, I use Notepad++ with a TM1 language addon. I have an automatic way of copy/paste TI and rules code to a (new) Notepad++ document with the TM1 language activated, and an automatic way to go back to TI and rules. It doesn't work 100% reliably all the time but when it fails, I copy/paste manually :-)
This is enough for me.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

jimhung777
Posts: 8
Joined: Mon Aug 07, 2017 5:39 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Questions for Code editor (TI/Rule)

Post by jimhung777 » Tue Nov 14, 2017 2:33 am

Thank you, Wim.

Recently I just study on how to create self-defined grammars for Atom since it has version control function.

Is there a possible way to convert UDL(User Define Language) from Notepad++ to Atom's grammars and CSS coloring?

:D :D :D

Wim Gielis
MVP
Posts: 1569
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Questions for Code editor (TI/Rule)

Post by Wim Gielis » Wed Nov 15, 2017 5:39 pm

Hello

I don't know Atom so I am not in the position to answer this question, unfortunately.
Maybe others have experience with it.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

User avatar
macsir
Community Contributor
Posts: 447
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Re: Questions for Code editor (TI/Rule)

Post by macsir » Tue Nov 21, 2017 1:54 am

jimhung777 wrote:
Tue Nov 14, 2017 2:33 am
Thank you, Wim.

Recently I just study on how to create self-defined grammars for Atom since it has version control function.

Is there a possible way to convert UDL(User Define Language) from Notepad++ to Atom's grammars and CSS coloring?

:D :D :D
Atom is good and I use it as my default programming editor at home. However, as PAW is the future and has more improved syntax highlighting functions, I won't bother to think a way to convert from Notepad++ to Atom.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

jimhung777
Posts: 8
Joined: Mon Aug 07, 2017 5:39 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Questions for Code editor (TI/Rule)

Post by jimhung777 » Tue Nov 21, 2017 3:16 am

Thanks for both responses above.

Due to several reasons, my company chooses to stay on TM1 10.2.2 which is unavailable to colorful syntax in the TI editor like in PAW.

That's why I need to find another editor for coding. And possibly the most convenient way is still Notepad++ for now.

:)

thomaskday
Posts: 4
Joined: Mon Apr 26, 2010 2:38 am
OLAP Product: TM1 / Planning Analytics Local
Version: PA2 Local 2.0.24
Excel Version: 2013

Re: Questions for Code editor (TI/Rule)

Post by thomaskday » Tue Nov 21, 2017 6:05 am

Hi jimhung777

There is a workaround, whereby in 10.2.2 or in PA2 Local you can use advanced rule editor with Architect. However, it is not a viable solution for every user.

The workaround is by installing Architect client before Office and Perspectives are installed on your client PC. You will also need to enable advance rule editor in your tm1p.ini file (AdvancedRulesEditor = T) and log into TM1 with Architect. It works just fine. One caveat, if you open a rule in Perspectives it will crash your Excel session. All other Perspectives functionality works just fine.

Yes, I appreciate IBM will deprecate Architect /Perspectives sometime soon. Yes, I appreciate that PA2 and Workspace is the future, but we are still waiting for some bugs to be fixed (active form client memory runaway), missing PAX features (drill through) along with security mode 6 before we fully embrace PAX/PAW.

For what its worth we are using PA2 local with Perspectives client for the time being. I expect we will fully embrace PAX/PAW early in the new year with 2.0.30 or 31. (current release is 2.0.28).

Hope this helps.
Thomas

User avatar
Steve Rowe
Site Admin
Posts: 1688
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Questions for Code editor (TI/Rule)

Post by Steve Rowe » Wed Nov 22, 2017 9:24 am

Hi Thomas, would you mind giving some more detail on the use case for active form client memory runaway?

thomaskday
Posts: 4
Joined: Mon Apr 26, 2010 2:38 am
OLAP Product: TM1 / Planning Analytics Local
Version: PA2 Local 2.0.24
Excel Version: 2013

PAX Active Form Client Runaway Memory

Post by thomaskday » Thu Nov 23, 2017 2:47 am

Steve Rowe wrote:
Wed Nov 22, 2017 9:24 am
Hi Thomas, would you mind giving some more detail on the use case for active form client memory runaway?
Sure Steve.

In PA2 Local there is a known bug in PAX client relating to active forms consuming all available client memory. If you have an active form with more than 1 dimension nested on the rowset, with zero suppression turned on, the active form will runaway and consume all available client memory until Excel fails. It consumed all 16gb on my notebook. The cube was small and sparse.

I came across this by accident doing testing between Perspectives and PAX. The same Active form in Perspectives works fine.

The bug is serverside, not client side. The root cause is when the server is returning the data call it is not doing so efficiently (zero suppression is not working as it should). The active form is fetching all records and not just those after zero suppression.

I raised a PMR and finally was advised it was a known issue. I also spoke with an IBM Worldwide Technical Executive who confirmed there are 2 fixes coming. One is a workaround for PAX (being released very shortly) which will require a change to any existing active forms. This is not really practical if you have many active forms in production! The second is a proper server-side fix which is expected sometime early next year.

We want to go "all in" with PAX/PAW, but have 3 items causing us to wait. Active form issue above, cube drill through in PAX (missing feature) and the pending security mode 6. We have deployed PA2 local (TM1 Server 11.0.002) with Perspectives. Looking forward to working with PAX and PAW when these updates are made.

Hope this helps.

Cheers
Thomas

Post Reply