I have found the CalcScript user style extremely useful of late as I had to debug some (over) complicated IF statements and ended up finding that they were not doing what was expected due to things like missing ENDIFs and IFs instead of ELSEIF statements which Essbase doesn't necessarily pick up (at compile time or run time). Since Notepad++ allows you to set up collapsible sections (e.g. between IF and ENDIF) it makes it much easier to navigate.
As before, the easiest way to install them is to do the following:
- Open the View menu
- Select User Defined Dialogue
- Click Import button
- Browse to and open the downloaded xml file (do this for each, one at a time)
CalcScript User Defined Style: CalcScript.xml
MAXL User Defined Style: MAXL.xml
MDX User Defined Style: MDX.xml