Skip to main content
C
cons1
July 16, 2026
Question

Workforce Planning Formula - derived output from formula 1 is the source data of formula 2

  • July 16, 2026
  • 1 reply
  • 41 views

Hi OneStream team, 

Is it possible to use the derived output of formula 1 to be used by another formula?

Is it also possible to migrate formulas to another application instead of recreating them? I tried extracting the whole workspace, however, it does not override the formulas. 

Also, when filtering register grid, will it possible to view data or filter for all pages?
For instance, I have 10 pages and I filter cost center, it should filter the values from page1-10.
Currently, it can only filter within the same page. 

Thanks for the assistance. :)

1 reply

DavidSebenaler
DavidSebenaler
Member
July 17, 2026

To get around the filtering issue, instead of creating a million different filter groups, I created a separate grid view of the register using a SQL data adapter querying the solution table. Very basic SELECT * FROM lima1.XFW_LIM_Register  (fixed term planning register table - change to limb1, etc. as necessary). The problem with doing this is none of the security defined in the solution applies to this grid view so you have to be very careful in limiting access to the grid view to admins/super-users.

When it comes to migrating formulas I believe they are included in the JSON extract (Settings>Configuration) that can be used to create a new instance of LIM. The extract also includes several other artifacts though so it may or may not be suitable for your use case.

For derivate formulas I’ve been creating helper accounts (accounts created in LIM NOT in the dim library) that store the calculation results for formula 1 and then referencing the helper account in formula 2. The calc plan will automatically sequence the formulas for you and won’t allow you to create circular formula references. Downside with this approach is you have to bypass all of these helper accounts in the transformation logic for the workflow integration if they truly are helpers and do not needed to be reported on in a cube. Also can pose an extra challenge to filter out these helper accounts in custom reporting built on top of the calc plan. 

Terms & ConditionsAccessibility statement