02-16-2023 12:35 PM
We are in cloud OneStream environment and our retention policy for Non Production is 7 days and Production 365 days ( I think ). Restore from backup does whole environment restore and not application by application. We have multiple application including PLP and I was wondering if anybody has figure out way to restore application.
Any help or procedure or steps are apricated.
*migrated from champions
02-17-2023 05:24 AM
Ok, we need to clarify terms here:
It's absolutely possible to restore an individual Application Database from the backup window. You have to request it in our ServiceNow:
This procedure will restore all tables in the Application, including any custom solution table that might exist. If you cannot find that option, contact Support and they'll send you a direct link.
If you want to restore only the state of an individual solution, i.e. only solution-specific tables (like only PLP tables), that's a custom procedure. You can discuss it with Support; it's technically doable but unlikely to give good results - those tables typically reference other elements in the Application, that might have since changed, resulting in various issues.
If you want to perform your own backups, typically as part of your development practices, you can schedule extracts via Data Management, relying on either the built-in features or custom rules. Some people use custom solutions with git, the REST api, and so on.
04-05-2023 11:32 AM
Thanks @JackLacava. I understand we can restore application with above but what about Cubes? for example we have application call AB_XYX and under that application I have PnL,BS and CapEx cubes. If I want to restore CapEx or BS only cube can this be done in OneStream?
04-05-2023 11:57 AM
If you want cube-level backups, you will have to take them manually with DM extracts of base data in those cubes. You can then reload that data.
An alternative, depending on how that data is generated, can be to use the Preserve Data feature instead, which you get in the Workflow Status screen once a Input profile is locked:
This ensures source data in Stage is preserved, so you can later revert to that ( and then reload it into the cube).