The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
BrandonG
4 years agoNew Contributor II
Running a Custom Calculation from a Business Rule with a MemberFilter for Time periods
We are trying to do a multi-year planning application. One requirement is the ability to calculate out-months into the next year of the plan.
One solution that would be very useful is the ability t...
ckattookaran
4 years agoValued Contributor
I'm assuming that you are going to use a DM sequence to execute this. You can pass time in the DM step to run for multiple periods.
BrandonG
4 years agoNew Contributor II
This is the current solution, but it would be nice to run the Custom Calculation directly. The Data Management Tasks are filling up the Task window when running over many data units.
- JohnMorehead3 years agoNew Contributor III
If you want to run a Custom Calc BR from another rule, such as an Extender Rule, you can do so with the following example code:
- victorthomsen2 years agoNew Contributor II
Do you have packages imported outside of OS Business rules? in VS or VSC? It does not look like OS env
- JohnMorehead2 years agoNew Contributor III
I'm not sure I fully understand the question, but that is a screenshot from Visual Studio Community, where I do most of my coding. I have brought in references to the OneStream DLLs so that it will correctly recognize the OneStream functions/API.
- ckattookaran4 years agoValued Contributor
I'm still not sure how you can call it still.
- BrandonG4 years agoNew Contributor II
Look for "BRApi.Finance.Calculate.ExecuteCustomCalculateBusinessRule" in the Business Rule Editor.
Maybe this function is/was deprecated, but it would be very useful in cases where you need to run a calculation against custom time periods.
Thanks though!
- ckattookaran4 years agoValued Contributor
I do see that. However, to use that, you still need a DM job for the user to execute it. Or they should have access to run an extender rule (which will lead to opening the business rules page to the user!!!). I cannot think of a way to do it unless you go the route of dashboard buttons and extender rules. When you say a DM job is triggered for data units, how is that being called?
Related Content
- 8 months ago