Forum Discussion
Solved
Slope, Correll and Intercept Functions
Is it possible to calculate slope, Correll and Intercept for a given factors vary by 12 periods using OS Finance Rules? If so, what are the libraries, I need to Import? Appreciate any suggestions how I can implement this in OS.
Thanks for your response.
Yes, the linear regression calcs like Slope, Correll, Intercept are currently done in Excel however we are moving from Excel to OS.So we need to automate these calcs in OS using Business Rules.
Period/Amount Entity P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Slope Correll SQRT Intercept A X X X X X X X X X X X X B X X X X X X X X X X X X I am not sure if this is a use case for Sensible ML as I haven't used it before. But does OS have code snippets to perform linear regression calcs in OS? or any suggestions to achieve this type of calcs using OS business rules.
2 Replies
- JackLacava
OneStream Employee
For advanced math, OneStream only contains standard .Net functions like https://learn.microsoft.com/en-us/dotnet/api/system.math?view=netframework-4.8.1. Also, if you know you can achieve the calculations with Excel formulas, you can set them up in Spreadsheet.
However, you can add any .Net library you want, for example https://numerics.mathdotnet.com/. If you're in a Cloud environment, you will have to open a ticket with Support to have it installed.
Depending on what you want to achieve, you might also want to investigate the Sensible ML solution.
Thanks for your response.
Yes, the linear regression calcs like Slope, Correll, Intercept are currently done in Excel however we are moving from Excel to OS.So we need to automate these calcs in OS using Business Rules.
Period/Amount Entity P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Slope Correll SQRT Intercept A X X X X X X X X X X X X B X X X X X X X X X X X X I am not sure if this is a use case for Sensible ML as I haven't used it before. But does OS have code snippets to perform linear regression calcs in OS? or any suggestions to achieve this type of calcs using OS business rules.
