Forum Discussion
Solved
Data retention and deletion
As shocking as it may seem, someone has decided that we actually should delete data from OneStream. In this case, we've been instructed to retain a maximum of five years of data. Everything older tha...
- We set up "Reset Scenario" Jobs by S# by Yr.
We use OS for FP&A with regular corp reorgs. Hence, we need to regularly "wipe clean" some of our datasets.
1. We have been using "Reset Scenario" DM Jobs to "wipe clean" selected datasets as linked below.
- https://documentation.onestream.com/docs/Content/Design%20and%20Reference/Application%20Tools/Steps.html
- Clear Stage Data and Cube Data
2. As a back-up, I suggest making a copy of the current app if enough storage in your non-Production environments.
- https://onestreamsoftware.service-now.com/support?id=sc_cat_item&sys_id=c4dab2d7db24d4d039a0d6fa4b9619bd&sysparm_category=f375d8361bfb6d10987cc88b234bcbb5
I don't think a scenario reset will work for us as we definitely want to keep most of our Actual data, just for one example. We want to selectively purge one year of data across every scenario, not purge one scenario absolutely.
I did consider making a "storage" scenario that would hold a backup of a scenario so I could reset the original scenario, then import all but the oldest year of data from the copy, then reset the copy itself. However, that loses a lot of other audit data, drillback info, stage data, etc. that we'd rather keep for those years that are still recent enough to retain.
