Need Table names of Legacy Reports, Dashboards and Migrated Platform Analytics tables

[Sohail7]

Hi Team,

We are planning to perform a clone from Production to all Sub-Prod environments this weekend. Some of the data required for testing is missing in the Sub-Prods. Could you please help provide a list of table names that are related or interlinked to the old (Legacy) Reports and Dashboards, as well as the new (recently migrated to Platform Analytics) Dashboards and Visualizations?
This is needed because I must ensure that these tables are not excluded if they are currently excluded in the clone profile.

We use the Sub-Prods for debugging, but we often lack the necessary data to reproduce issues, such as scheduled reports or table data linked to Reports/Dashboards. I tried importing the XML from Production, but it does not include child records, which makes the process difficult. Since we now have an opportunity with the upcoming clone, we want to make sure we do not miss this chance to include all relevant data.

[Mark Manders]

Why not perform a clone with a temp clone profile with only the OOB exclusions and preservers? Anything related to reporting also needs the data. 

The number of tables related to reporting (both old and new) is huge and you always run the risk of missing a table that is linking reports to tabs to dashboards, or something like that.

Maybe running a script to remove the sensitive data you don't want there, or adding those tables to the exclusions/preservers as well, would be an easier solution.

[Sohail7]

The client is not allowing us to create a new clone profile and wants us to use the existing one, as they have certain restricted data tables that they do not want to risk.

[kaushal_snow]

@Sohail7 ,

If you do a full clone and want to preserve both legacy reports/dashboards and the newer platform analytics / migrated dashboards/data visualizations........you need to make sure you include, at minimum, the tables sys_report, report_stats, and the platform analytics tables such as pa_dashboards, pa_tabs, pa_m2m_dashboard_tabs, as well as new analytics tables prefixed with par_ (e.g. par_dashboard, par_visualization, etc.)........

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.