Skip to main content
Newcomer
Dec 9, 2021 2:47 PM UTC
Solved

Extract Formulas for all accounts

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?

LeeBAnswer
Contributor
Dec 9, 2021 3:09 PM UTC

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

 

3 replies

LeeBAnswer
Contributor
Dec 9, 2021 3:09 PM UTC

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

 

ChristianW
Employee - Advisor
Employee - Advisor
Dec 9, 2021 3:45 PM UTC

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

ChristianW_1-1639064726838.png

 

BeeswingAuthor
Newcomer
Dec 9, 2021 3:20 PM UTC

Perfect!  Exactly what I needed. 

Many thanks