Copy Application

[BCG]

Hi All,

how to copy application in OneStream from front end as well as from DB side

if any have performed these tasks kindly navigate the steps please.

[AK]

This is for cloud implementations:
Cloud Administration Tools is a MarketPlace solution, and it contains multiple cloud service functionalities including Manage Applications.
Using Manage Applications, System Administrators can copy existing applications to create new applications or replace existing applications within OneStream XF.
You can download Cloud Administration Tools from MarketPlace, load the package in the application and complete the setup process.

[ChrisLoran]

Just be aware that if you are copying an application, then if you are using BI Blend then these BI Blend tables will exist in a separate/external database. If you are working in the same environment then you need to ensure you're copied application isn't pointing to the production tables for BI Blend.

[MarcusH]

You can copy an application by going to Application | Tools | Load/Extract then select 'Application zip file (All except Data and FX)'. If you need data as well you have to import it somehow. If the application is being created in a different environment you will have to export and import security if there are security groups on the metadata, workflows, cube views etc.

Another thing you have to keep in mind if you are copying an application using the extract to XML (or Application zip file) is that it does not include any Market Place solutions you might have installed. If they are all reporting/audit solutions it is not a big problem - just install again. If they are collecting data (eg Acquisition Register), then that is more of a problem.

[Harv]

When an app is copied to a different environment, first we extracted & loaded the security XML (users & groups). Then the app copy was made to this new environment using Cloud Admin tool. Even after this the artifact level security on the metadata, workflows, cube views etc. did not move. All the security groups in the artifacts showed "Not Found". What did we miss? Appreciate your response.

[MarcusH]

I am not sure how the Cloud Admin tool copies the application but I would guess it is doing a database copy. The problem is that in the source environment the security groups have a different signature to the new environment. The OS tables store the security signature not the security group name. You can import the security groups into your new environment but that won't solve the problem. You need to update the metadata, dashboards, cube views etc with the correct signature for the security groups. As a test, export a small section of the Cube Views (or Workflows, Dashboards) from the source environment. Make sure some of the Cube Views have security applied. Then import that XML into the new environment. That should apply the correct security groups. If you are happy with that, then you can go onto export the rest of the metadata, artefacts etc. and import.