OneStream Community

TheJonG · 07-22-2022

Ok, so I may be a bit biased here given that I wrote the book, but I think every OneStream consultant, administrator, and power user should read The OneStream Finance Rules and Calculations Handbook. Before I tell you why you should read it, I’ll tel...

TheJonG

Setting up data extraction on a quarterly basis is easy and could be done with a combination of Data Management Sequences, Task Scheduler, and an optional dashboard. For example, after the quarter is closed, you would extract all data for that quarte...

TheJonG

Ok I think I understand. Perhaps instead of using an array, you can put the values in a dictionary with the Name being the decimal name and the Value being the absolute value. Then you can pull the max value along with the name and then use the name ...

TheJonG

I'm not sure why you would need to do that. You have the original amount from the dAmount_1 variable and then you can set the absolute value to a new variable.

TheJonG

Math.Abs(dAmount_1), Math.Abs(dAmount_2), etc should give you what you need.

TheJonG

Hi - There is a Method Type specifically for Assigned Workflow Entities.

OneStream Community

User Statistics

User Activity

OneStream Finance Rules and Calculations Handbook

Re: Extract incremental data from cube

Re: Absolute Value in a UD8 Formula

Re: Absolute Value in a UD8 Formula

Re: Absolute Value in a UD8 Formula

Re: How to use Entity Assigned in workflow into Dashboard Data Adapter