OneStream Community

chul · 03-20-2023

Mapping can be complex. Here’s an example and a solution to minimize the writing of business rules and use the out-of-the-box OneStream functionality to maintain them.The data source provided is simple and straightforward.There are only seven columns...

chul · 02-16-2023

Have you run into the situation where a customer has a KPI or statistical account that they want OneStream to dynamically calculate for one Scenario Type and users to enter for another? If you’ve worked with OneStream’s dimension library, you know th...

chul · 01-09-2023

Many of us have been through the rigors of data validation at some point during a system implementation – and if you haven’t, lucky you. For the unlucky ones, you’ve likely encountered someone on your team explaining, in not-so-great detail, that “th...

chul

You can put a parent in the first column of the calc definition of the WF Profile and it will run the confirmations on that member when the Confirmed box is checked. FYI - You've got C# listed twice in your formula (C#Local & C#EUR)

chul

Also ensure that you don't have a member formula on the target scenario as it will run first upon calculation/consolidation.

chul

Best practice is to condition the api.data.calculate statement to run only for base entities and local currency. If you're missing the condition, it's running unnecessarily and copying your translated amounts from your source.

chul

At this point, my opinion is that this decision is purely customer driven as they will be responsible for maintaining the rules and member formulas post go-live. I would guess that there are currently far more OneStream consultants with VB.net experi...

chul

If you're debugging a finance rule or member formula, be sure to use the api equivalent, api.logmessage.

OneStream Community

User Statistics

User Activity

Can complex transformation rules be written without using code?

Can a member have two or more different Account Types?

Making sense of the Scenario settings

Re: Confirmation rules for other entities ?

Re: Consolidation slow when after copying from scenario to another

Re: Data seed and fx rate

Re: Visual Basic or CSharp

Re: Where Is Console.WriteLine Written To