Allow large numbers to be stored in OneStream database
The OneStream precision limit is set to DECIMAL(28, 9) for numbers getting loaded to database, This is a total of 28 characters with 9 of them decimal places. We have larger numbers that need to be loaded to the database. The factoring approach suggested by the OneStream support team does not work for us.
As per the below comments by the support team in Case CSRC0147989, can an enhancement be made to allow larger numbers to be stored in database?
“While SQL Server can support up to 38 digits, implementing this would require changes to the product thus making it an enhancement request. The only fix is to update all the numeric columns in the DB to accept a larger precision.
We recommend that you log an enhancement request in IdeaStream so product engineering can consider it.”
