12-13-2021 06:59 AM - last edited on 05-02-2023 10:45 AM by JackLacava
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?
Solved! Go to Solution.
12-13-2021 09:23 AM
Visual Basic is the language option to select.
12-13-2021 09:23 AM
Visual Basic is the language option to select.
12-13-2021 11:41 AM
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.
12-13-2021 11:37 AM
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
12-13-2021 11:43 AM
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.
05-11-2022 12:15 PM
how did you extract metadata formulas?
05-12-2022 04:53 AM
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.