Notepad++ for TM1 Rules & TI – Updated!

With the new release of Notepad++ yesterday to v6.4.1, I thought it was a brilliant time to update the TM1 Turbo Integrator and Rules Syntax files to be based on TM1 v10.1.0 Reference Guide.

The new version xml file can be found here: TM1 v10.1 Notepad++ update

In this release, we’ve added a couple of new TI functions such as:

  1. Synchronize: Used in a TI script to force serial execution of a designated set of its processes.
  2. CubeSaveData: Serialises a cube

We’ve also moved some functions into a more appropriate grouping (based on Official IBM Cognos TM1 10.1.0 Ref Guide) and also fixed the IF statement problem in the previous release.

If you haven’t installed a user defined language in Notepad++ before, please follow the instructions below:

  1. Start Notepad++ and select View from the top toolbar and then select User Defined Dialogue.
  2. Click Import. Select the TM1 v10.1 update.xml file provided above and click Open, then restart Notepad++.
  3. To use the add-on, go to Language and select TM1 from the list.

Below are some screenshots of Cube Rules and TI process in Notepad++ after applying the language markup:

Sales Cube Rules

Sales Cube Load TI

I hope that you find this useful. If you would like assistance developing Turbo Integrator Processes or Cube Rules for your TM1 Solution, the friendly team of Consultants at InfoCube Consulting Australia can help. Just pop us your details in the form on this page and we’ll get back to you.

If you like this post, please spread the love…

10 comments on “Notepad++ for TM1 Rules & TI – Updated!

  1. Tom says:

    How do I install notepad++? It seems like a really nice tool.

    1. Hi Tom,
      It is a very handy tool to have! You can install Notepad++ from their website:
      http://notepad-plus-plus.org/

      Cheers,
      Nova

  2. Heru Purnomo says:

    Hi Nova,
    Thanks for your sharing. It’s worth.

    Cheers,
    Heru

  3. Peter Verco says:

    I couldn’t find import in the view menu, but language/define your language/import seemed to work

    1. Hi Peter,

      Thanks for that! Notepad++ moved the “Define Your Language” option from the View tab to Language tab as shown below:

      Older version: http://extm1.wpengine.com/wp-content/uploads/Notepad++-older-version.png

      New version: http://extm1.wpengine.com/wp-content/uploads/Notepad++-newer-version.png

      Cheers,

      Nova

  4. lihnchin says:

    it doesnt support #REGION!!!

    1. Thanks lihnchin,

      The problem with #Region and #EndRegion is that they are preceeded by a comment symbol “#”, which Notepad++ then assume as comment rather than folding style code.

      Will look into this. Thanks.

      Nova

  5. Pablo Tirado says:

    Hi Nova

    Just a suggestion: change the Operators 1 Color Sytle (in the Operators style tab) from red to another color because it is the same color that NP++ use to indicate the open and close brackets pair when you put the cursor over one of them.

    This function is very useful especially when you have long rules with a lot of brackets.

    Regards.

    1. Thanks Pablo,

      Great suggestion. I’ll look into making this clearer in the next update that will include TM1 10.2 new functions (which hopefully would be soon!).

      Cheers,

      Nova

  6. Ambrus says:

    Hey Nova, thanks a lot for this! I guess the whole TM1 world is using it. FYI If you’re using the Sublime Text editor find syntax highlighting for it at: https://github.com/iamambrus/tm1-sublime

This site uses Akismet to reduce spam. Learn how your comment data is processed.