03-14-2023 06:25 PM - last edited on 05-02-2023 09:58 AM by JackLacava
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.
Solved! Go to Solution.
03-15-2023 11:26 AM
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.
03-15-2023 07:19 AM - edited 03-15-2023 07:22 AM
For advanced math, OneStream only contains standard .Net functions like System.Math. 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 Math.NET. 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.
03-15-2023 11:26 AM
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.