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 🙂
Excellent !
Brilliant. I use Notepad++ all the time. Is anyone working on an MDX language support (hyperion version/std not SQL Server) ???
Thanks Chinmay and Nigel.
I was planning to make one for Maxl and MDX, but thought calc script needs more priority :0)
Even better with Textpad – http://essbaselabs.blogspot.com/2008/08/working-with-essbase-files.html
That's a nice feature, thank you pointing it out. You can soon except something similar in Notepad++. I'm working on it and will let you all know once it is done.
Hi CV. Just chucked up the user defined styles which I use for MAXL and Calcscripts. Feel free to check it out as I think it might help. http://www.hypersbase.com/2011/06/notepad-user-defined-styles.html
I actually never knew about the folder option and I added it into my style. Thanks for the tip.
Thanks it's really usefull
Please look at https://orahyplabs.com/2011/07/essbase-mdx-and-maxl-language.html for the entire Calc, MDX, Maxl highlighting
Love this, thanks. Anyone out there have one for DRM formulae?
Thanks very much….you saved a lot of time:)
Thanks!
Didn't work for me. I downloaded the file and copied into the Notepad++ folder. restarted Notepad++. Essbase doesn't appear anywhere.
@Anon this folder will also have files like stylers.xml, shortcuts.xml is that the folder? Also the file name should be userDefineLang.xml
Hi Kelvin,
After adding your file I renamed it to UserDefine.xml and placed it under the folder mentioned in your post. The folder also contains a file called Langs.xml.
After restarting my notepad++, I'm can see "Essbase calc", "Essbase MAXL", "Essbase MDX" under Languages option. However the highlighting/ color of the calc script doesn't change when i select "Essbase calc" language. What am I missing here ?
Same to me. I see ESSBASE_CALC, ESSBASE_MXL, ESSBASE_MDX in the menu Syntax, but nothing highlighted if choose one. Tried to recognize this script:
//ESS_LOCALE Russian_Russia.MS1251@Default
SET MSG SUMMARY;
SET UPDATECALC OFF;
SET AGGMISSG ON;
SET EMPTYMEMBERSETS ON;
SET FRMLBOTTOMUP ON;
SET CREATEBLOCKONEQ ON;
SET CACHE ALL;
SET CACHE HIGH;
SET LOCKBLOCK HIGH;
SET CALCPARALLEL 8;
SET CALCTASKDIMS 2;
FIX (
"L_Input"
"R_NA"
"Age_NA"
"Pe_NA"
"C_NA"
"P_NA"
"BUD"
)
CLEARDATA "AC_002";
CLEARDATA "AC_007";
ENDFIX
Got it! For some reason updated Notepadd++ doesn't recognize Essbase_userDefineLang.xml syntax (possibly udlVersion="2.0")
need to be reposted with new xml syntax =)
@anon try renaming it to userDefineLang.xml
Thanks! this helps a lot 🙂
You Are Amazing!
Awesome..!
Excellent – just what I was looking for. Really helps a lot 🙂
Your xml wonderfully syntax highlights calc scripts in Notepadd++ v6.9.1! Thanks for sharing your hard work with the rest of us. May your generosity be repaid ten-fold.
–Enrique
Thank you Celvin
Excellent
Thanks for putting this together, I use it all the time!
The Links are gone. I got a new computer and I can’t live without this defined language.
I had to change providers and I think when the files were copied over they forgot the uploads folder. It’s restored now.
Celvin ji .. Links are not working .. as this is a must have while I work on my everyday scripting .. please update the links
Did it work? You need to perform a save as to get the XML.