# Deleting a report from the data mart

Available in...

* Big Data Platform
* Cloud API Services Platform
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Management Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* MDM Platform
* Qlik Cloud Enterprise Edition
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

## Procedure

1. In the Data Explorer perspective, open an editor.
2. Enter the following SQL query in the editor and execute it in the order shown below:
   ```
   use talend_dq61;
   /*must execute the sql in this order*/
   /*1. delete data from tdq_indicator_value table*/
   delete from tdq_indicator_value where analysis_pk in (select an_pk from tdq_analysis where rep_uuid in ('_EuRp8Ey8EeWI7MB95QH5HA', '_cabpUUzUEeW6FuESwuuXqA'));
   /*2. delete data from tdq_overview_indvalue table*/
   delete from tdq_overview_indvalue where an_pk in (select an_pk from tdq_analysis where rep_uuid in ('_EuRp8Ey8EeWI7MB95QH5HA', '_cabpUUzUEeW6FuESwuuXqA'));
   /*3. delete from tdq_set_indvalue table*/
   delete from tdq_set_indvalue where an_pk in (select an_pk from tdq_analysis where rep_uuid in ('_EuRp8Ey8EeWI7MB95QH5HA', '_cabpUUzUEeW6FuESwuuXqA'));
   /*4. delete from tdq_analyzed_set table*/
   delete from tdq_analyzed_set where match_ind_pk in(select m_pk from tdq_match_indvalue where analysis_pk in (select an_pk from tdq_analysis where rep_uuid in ('_EuRp8Ey8EeWI7MB95QH5HA', '_cabpUUzUEeW6FuESwuuXqA')));
   /*5. delete from tdq_match_indvalue table*/
   delete from tdq_match_indvalue where analysis_pk in (select an_pk from tdq_analysis where rep_uuid in ('_EuRp8Ey8EeWI7MB95QH5HA', '_cabpUUzUEeW6FuESwuuXqA'));
   /*6. delete from tdq_table_analyzed_set table*/
   delete from tdq_table_analyzed_set where an_pk in (select an_pk from tdq_analysis where rep_uuid in ('_EuRp8Ey8EeWI7MB95QH5HA', '_cabpUUzUEeW6FuESwuuXqA'));
   /*7. delete from tdq_analysis table*/
   delete from tdq_analysis where rep_uuid in ('_EuRp8Ey8EeWI7MB95QH5HA', '_cabpUUzUEeW6FuESwuuXqA');
   ```

   In this example, you want to delete the two reports which have the identifiers \_EuRp8Ey8EeWI7MB95QH5HA and \_cabpUUzUEeW6FuESwuuXqA from the talend\_dq61 data mart.
3. Execute the SQL query to delete the reports.
4. To make sure the reports have been deleted, in an SQL editor, re-run the following SQL query:
   ```
   use talend_talend_dq61;
   /* get report UUID */ 
   select  REP_UUID, REP_LABEL  from tdq_analysis where REP_LABEL like 'c%'
   ```

## Results

The two reports which have the identifiers \_EuRp8Ey8EeWI7MB95QH5HA and \_cabpUUzUEeW6FuESwuuXqA have been deleted from the data mart.

The reports have been deleted from the TDQ\_ANALYSIS table. All facts (analysis results) related to these reports have been deleted from the fact tables.