Skip to main content
V
vmanojrc30
March 14, 2023
Solved

Slope, Correll and Intercept Functions

  • March 14, 2023
  • 1 reply
  • 0 views

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.

 

 

 

    Best answer by vmanojrc30

    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                
    EntityP1P2P3P4P5P6P7P8P9P10P11P12 SlopeCorrellSQRTIntercept
    AXXXXXXXXXXXX     
    BXXXXXXXXXXXX     

     

    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.

     

     

    1 reply

    J
    JackLacava
    March 15, 2023

    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.

    V
    vmanojrc30AuthorAnswer
    March 15, 2023

    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                
    EntityP1P2P3P4P5P6P7P8P9P10P11P12 SlopeCorrellSQRTIntercept
    AXXXXXXXXXXXX     
    BXXXXXXXXXXXX     

     

    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.

     

     

    Terms & ConditionsAccessibility statement