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.
Looking around a little more, I still see millions of rows in stage. A reset didn't clear those. Is there an existing way to clear old years of those?
I suggest setting up additional "Reset Scenario" DM Jobs using a range of Yrs by S#.
- Stage tables are critical to the "Data Integrity" in OS apps.
- The best option is to use new RS Jobs to safely "wipe clean" your apps' many Stage tables in OS.I'm thinking I may have just misread my own stage tables. I had manually cleared a few years of stage from the most common scenarios before I started using the Reset. As I ran the Reset for more and more scenarios, I expected to see the total rows shrinking. However, I was apparently more thorough in my manual deletes than I realized as there's no data in stage prior to the years I want to keep. (What I suppose this means is I know my data and cleared exactly what needed to be cleared. I just wouldn't have needed to do it if I'd used the Reset first.)