06-02-2020 07:38 AM
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?
06-04-2020 11:04 AM
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
06-08-2020 11:45 AM
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)