Forum Discussion

SaurinPatel's avatar
SaurinPatel
New Contributor III
2 years ago

Application Restore

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.

Saurin Patel

*migrated from champions

Infrastructure
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    Ok, we need to clarify terms here:

    • OneStream cloud environments contain multiple Applications.
    • A single OneStream Application Database includes all its own metadata, dashboards, rules etc, including any custom table that might have been created by the customer or by Solutions.
    • Marketplace Solutions, like People Planning, are a set of components (typically dashboards and rules) that get loaded into an application. On first launch, they might require to create some custom tables in the Application database (or more rarely, the Framework one).

    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.

  • SaurinPatel's avatar
    SaurinPatel
    New Contributor III
    2 years ago

    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?


    Saurin

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      2 years ago

      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).