OneStream Community

LeAnnTDang · 08-09-2024

Hello, We have a DM that receives one set of parameter inputs and runs the business rule for a target entity. We would like to convert this DM to run on multiple sets of inputs for multiple sets of target entities. What is the best setup? In the exam...

LeAnnTDang · 09-16-2022

For Entity transformation rule, we want to build logic so that Source entity looks at its parent entity in one of our entity hierarchy in OS dimension, read and then map to the parent entity text8 assignment, then map to that entity the text8 assignm...

LeAnnTDang · 09-16-2022

Hello, I am attempting to build a simple line chart through BI Viewer with Cashflow amounts in Y axis and Time (month-year) in X axis. I cannot get it to sort properly so it display data to flow through time. In the X axis, I choose Time for Argument...

LeAnnTDang · 08-12-2024

I'm not following entirely. So in this example, it's true that I didn't specify the |!ml_InactiveNoStatus_WF_Entities!|, which is the targetted entity filter. When we run it for multiple sets of source and target, we will also have sets that don't ha...

LeAnnTDang · 08-12-2024

The error message was "Summary: Error processing Data Management Step 'CopyDataFromLandAcqProforma'. Invalid parameter. Entity Filter, E#|!ml_InactiveNoStatus_WF_Entities!|." Is your recommendation for namevaluepairs still aplicable for this error me...

LeAnnTDang · 08-12-2024

I have. However, the multiple sets of selections will not be used in all scenarios. If I preset 20 DM steps, and only 10 are being used, the job erred out at step 11, while subsequent steps need to be run after this step as well. Is there a way to by...

LeAnnTDang · 03-14-2024

Hi Chris, Thanks for the note. Although I couldn’t use the loop feature for our case, I managed to break down the investment goal seek calculation into the following steps: Recognize the target IRR. Calculate the NPV of the cash flow stream using the...

LeAnnTDang · 03-11-2024

Hi Chris, Thank you for the sample script. I am still a noob with the OS business rule so I apologize for this silly question. Your example seems to be an Extensibility Rules while your recommendation above is to try out with a Finance Business Rule....

OneStream Community

User Statistics

User Activity

DM job to run the one business rule for multiple sets of source and target parameter

How to setup transformation rule to look at parent text value in entity dimension?

BI Viewer - Line chart Order by Time dimension

Re: DM job to run the one business rule for multiple sets of source and target parameter

Re: DM job to run the one business rule for multiple sets of source and target parameter

Re: DM job to run the one business rule for multiple sets of source and target parameter

Re: Goal Seek function equivalent In onestream

Re: Goal Seek function equivalent In onestream