Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

Is there a setting that needs to be changed to allow Zero's to loaded?

Originally posted by Craig Masters 4/5/2018 Is there a setting that needs to be changed to allow Zero's to loaded? When I load a file with zeros, those lines are stripped out in the staging table...
Data Sources
OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago
Originally posted by Puja Patel

Yup - On the Data Sources page, click on the specific data source you want to load zeros for. Then click on the 'Amount' source dimension. Under the Numeric Settings section, change 'Zero Suppression' to False. That will allow you to load zeros in through import.