Skip to main content
December 9, 2021
Solved

Extract Formulas for all accounts

  • December 9, 2021
  • 2 replies
  • 0 views

Coming from HFM, I'm used to having a single rules file that I can easily search through.

In OneStream,  the equivalent rules appear to be defined for each individual account as a metadata property. I.e.  the Formula.

Is there a way to extract all of the Account Formulas into a single file so that  I can search through it? Instead of having to click through each account in turn and opening up the individual formulas?

Best answer by LeeB

There is a report in the Application Reports MarketPlace solution.  The report is named "Formula List" and is in the category "Application Analysis". 

 

 

LeeBown_1-1639062570507.png

 

2 replies

LeeBAnswer
December 9, 2021

There is a report in the Application Reports MarketPlace solution.  The report is named "Formula List" and is in the category "Application Analysis". 

 

 

LeeBown_1-1639062570507.png

 

December 9, 2021

You can also use the Grid View tab, but it is one dimension at a time:

ChristianW_1-1639064726838.png

 

BeeswingAuthor
December 9, 2021

Perfect!  Exactly what I needed. 

Many thanks