Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

Workflow Profile - Entity Calcs - Calc Types

Originally posted by Chad Fortman

OS Version: 6.0

Platform: Cloud

 

Hello,

I am working on an enhancement for our automated change management process.  Lately the focus has been on Workflow Profiles.  Within the AuditWorkflowProfileEntityCalcs table (Application Database) you will find a column for CalcType which holds a numerical value.  I would like to find the enum or table that holds the friendly name that correlate to these values.  The API Details & Database Documentation help file does not seem to contain anything related to this column.  Anyone know anything about this?

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    Originally posted by Jeff Jones

    Chad,

     

    If you are not having a response from the OneStream community, you can always open a support request via the support portal and the OneStream support team can assist with this inquiry.

     

    Thank You

     

    Jeff

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    Originally posted by Chad Fortman

    Here is the solution, given by OneStream Support.

     

    There is a OneStream "calculate type helper" object that you can use to accomplish deriving meaning to the Calc Type codes stored in the database. Here is an example of using the CalcType helper to write Calc Types to the error log: brapi.ErrorLog.LogMessage(si, "Calculation Calc Type: " & CalculationType.Calculate)

    BRApi.ErrorLog.LogMessage(si, "Force Calculation Calc Type: " & CalculationType.ForceCalculate) BRApi.ErrorLog.LogMessage(si, "Force Consolidation Calc Type: " & CalculationType.ForceConsolidate) BRApi.ErrorLog.LogMessage(si, "Consolidate With Logging Calc Type: " & CalculationType.ConsolidateWithLogging)