Skip to main content
B
Beeswing
December 13, 2021
Solved

Formula extract - Notepad++ language

  • December 13, 2021
  • 3 replies
  • 0 views

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?

Best answer by TerryLedet

Visual Basic is the language option to select.

3 replies

T
TerryLedetAnswer
December 13, 2021

Visual Basic is the language option to select.

B
BeeswingAuthor
December 13, 2021

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.

T
tsandi
December 13, 2021

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

B
BeeswingAuthor
December 13, 2021

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.

O
Oscar
May 11, 2022

how did you extract metadata formulas?

B
BeeswingAuthor
May 12, 2022

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.

Terms & ConditionsAccessibility statement