I've extracted the formula file for all metadata formulas, and have notepad++ installed as my preferred tool for reviewing.
What language settings in Notepad++ do I need to use in order to replicate the colour and formatting of OneStream's internal formula editor?
Visual Basic is the language option to select.
Visual Basic is the language option to select.
Thanks, this worked for me. I just needed to adjust the String formatting, as it was defaulting to grey instead of the dark red/brown that I'm used to from HFM and OneStream.
Notepad++ will not provides you with intellisense nor code completion for any OneStream specific class. Using notepad++ for writing OneStream business rules online rather than the included code editor will be harder for sure. If your objective is to be able to write OneStream business rules offline I'd rather install visual studio community edition and add OneStream dlls as references instead
Thanks. I'm not familiar with Visual Studio, but will check it out if I need to do some real coding.
For now though, I just need something I can just open Formula extracts with, that lets me search and run compares. Notepad++ should be OK with that.
how did you extract metadata formulas?
Dashboards > Application Reports > Application Analysis > Formula List
It won't include business rules.
Also, it'll include all time stamped versions of formulas, even old redundant ones, so make sure you're looking at the right ones. The timestamps will be on the far right, and are easy to miss.
