If looking to migrate BITeamwork from one OBIEE environment to another please see this document,
As a reference to customers looking to achieve some type of advanced migration of comments from one version OBIEE to another or from environment to another environment, the list of tables below represent the core tables in BITeamwork that one would need to think about and consider heavily the content therein which may need to be changed or otherwise preserved depending on the specific subjective use case for your organization:
Other Q&A often asked on this advanced topic are as follows:
- Q: Does the report ID change? Does the dashboard ID change?
A: Check Web Catalog Manager and view report/dashboard object properties and compare after you've conducted your migration. Net new reports and dashboards will have different ids and properties and will therefore be recognized as different objects in BITeamwork.
- Q: Does the unique prompt context hash change? or GlobalViewStateID?
A: One will need to Compare an OBIEE 11g dashboard report comment submission to an OBIEE 12c similar dashboard report comment and verify GlobalViewStateID and PromptStateID and ContextURLParameters. Also verify DashPageUniquRef columns to determine if they match between OBIEE versions.