Essbase language for Notepad++ 25


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. 
  •  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. 
  •  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. 
  •  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 🙂
Advertisements

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

25 thoughts on “Essbase language for Notepad++