Blog Post
Hi chuckbo !
First a reminder : You can use the Object Usage Viewer that can help you find and highlights the impact of a change to an object in the application. It is implemented for :
- Cube Views,
- Data Sources,
- Transformation Rules
- Form Templates,
- Journal Templates,
- Confirmation Rules,
- Certification Questions,
All dashboard objects.
Then regarding the migration itself... The process should be rigourous. But first, you need to know if you are migrating within the same server if you host it yourself as the security could be different on the DEV vs PROD. That would have an impact on your security groups for your objects... but lets not overcomplicate and lets assume you are on the same server.
First, I would start my DEV being a perfect clone of the PROD. That means that DEV is an sql backup of PROD.
Second, I would have previously made an excel list of all object that were changed. From this list I would export them in XML.
Third, I would recommend to have another TEST environment being also a clone of PROD to test the migration.
Fourth, if the migration XML are migrating to TEST without issue, you can load the XML to PROD.
If you want to compare the XML between PROD and DEV, Onestream as a tool for that too!