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 to remove as the scenario no longer exists. I would think removing the old data would improve performance and reduce db size. Or am I unaware of the tools to perform such maintenance?
I guess at at a high level (perhaps over simplified) you can say there is not really integration from core OneStream down to Marketplace apps, it only works the other way. What I mean by that is, when you do an action in an app such as People Planning, that can initiate something to happen which modifies OneStream or a cube. When you make a change outside of a marketplace application's dashboards or in a cube however, there is no function to then automatically impact one or many marketplace apps.
Manually removing data always requires a thorough understanding of the solution and I would say that the 'safety' of doing so is dependant on the person doing it and having a back-up plan if things go wrong. The preferred method would be perhaps re-creating the scenario and using the interface to clear the data. In saying all that, I have manually cleared PLP data before.
- Daniel
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.
