Questions for Code editor (TI/Rule)

[jimhung777]

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.

[Wim Gielis]

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.

[jimhung777]

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?

[Wim Gielis]

Hello

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

[macsir]

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?

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.

[jimhung777]

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]

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

[Steve Rowe]

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

[thomaskday]

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