BCG
2 years agoNew Contributor II
Copy Application
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.
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.
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.