The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
JonKunert
1 year agoContributor III
Cleaning Data Tables of old data
I recently discovered that data from deleted Scenarios is not removed from many of the application data tables (XFW_PLP_Plan, XFW_PLP_Register, ...) Does anyone know why it remains and is it safe t...
M_L_Spencer
1 year agoNew Contributor II
To add on to what Daniel said - not all applications have those other marketplace solutions installed, so the core logic of OS, upon deleting a scenario (or even clearing the data from it) would need to run through checks for all different combinations of marketplace solutions to check and see if there was data that needed to be removed - any time a new Marketplace solution came out, the core logic would need to be updated to see if those solutions were in place and feeding data to the cubes.
Clearing the data without going through the scenario recreation would require executing SQL statements against those tables and would need to be pretty surgical about where you want to clear it. It would be a pretty cool tool though that had these standard marketplace tables embedded as a list in a dashboard somewhere where admins could go in and choose the solution/scenario they want to clear the data in, and the SQL behind the scenes would go clear it for them.
Related Content
- 2 years ago