Essbase language for Notepad++ 29


This is something not directly related to Hyperion, but there is Hyperion in it 🙂
 
People who don’t know about Notepad++, 
 
Notepad++ is a free (as in “free speech” and also as in “free beer”) source code editor, you can download it from http://notepad-plus-plus.org/
People who are using Notepad++ will be aware of the highlighting feature available for lot of languages.
 
It’s much relief to work on Notepad++ because of the highlighting feature, when compared to other editors where the monotonous black prevail (notepad and editplus).  There is in-built highlighting for more than 40 languages!!!!!
 
I use it a lot because it makes life easy while creating batch files, xml, unix scripts.
 
So I was searching for one with Essbase calc script based highlighting and ended up creating one!!!
 
Installation instructions
 
Follow the instructions below if Notepad++ is installed on your system (not running from a folder)
  •  Download the XML file to your computer. (Right Click the link and use “Save Link as…” option)
  •  Click start, run, type (or paste in) %APPDATA%Notepad++ (this will be the folder where you have config.xml) then click ok.
  •  Open userDefineLang.xml with a text editor.  If it does not exist, simply download/save the one you downloaded to this folder and rename it to userDefineLang.xml, you’re done!
  •  If you have an already defined User Language, open the file with your favourite text editor (such as notepad++ or notepad).
  •  Simply copy everything from the first file starting at <UserLang…> to </UserLang> and paste it at the end of the userDefineLang.xml right before </NotepadPlus> 
  •  Save the newly improved userDefineLang.xml
  • Restart Notepad++
Follow the instructions below if Notepad++ is run from a folder (Portable)

  • Download the XML file to your computer. (Right Click the link and use “Save Link as…” option)
  •  Go to root folder of Notepad++(this will be the folder where you have config.xml) t
  •  Open userDefineLang.xml with a text editor.  If it does not exist, simply download/save the one you downloaded to this folder and rename it to userDefineLang.xml, you’re done!
  •  If you have an already defined User Language, open the file with your favourite text editor (such as notepad++ or notepad).
  •  Simply copy everything from the first file starting at <UserLang…> to </UserLang> and paste it at the end of the userDefineLang.xml right before </NotepadPlus> 
  •  Save the newly improved userDefineLang.xml
  • Restart Notepad++
Follow the instructions below if you are using Portable Apps’s Notepad++
  • Download the XML file to your computer. (Right Click the link and use “Save Link as…” option)
  •  Navigate to Notepad++PortableDataConfig.
  •  Open userDefineLang.xml with a text editor.  If it does not exist, simply download/save the one you downloaded to this folder and rename it to userDefineLang.xml, you’re done!
  •  If you have an already defined User Language, open the file with your favourite text editor (such as notepad++ or notepad).
  •  Simply copy everything from the first file starting at <UserLang…> to </UserLang> and paste it at the end of the userDefineLang.xml right before </NotepadPlus> 
  •  Save the newly improved userDefineLang.xml
  • Restart Notepad++
Create a calc script in Notepad++ and change the language to Essbase from Language ->Essbase
 
 
FIX….ENDFIX IF…ENDIF will now show up as block, you can just use the expand/collapse buttons (+/-) to group them.
 
Hope it helps 🙂

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

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

29 thoughts on “Essbase language for Notepad++