Common Reporting > Deleted Data still show in report
One answer
Hi Cesar,
What tool are you using to create the report? RRDI has a general parameter to determine if deleted records need to be shown or not. Also, when creating the queries sometimes the verification is done only on the source table, therefore the deleted records in the target table need to be explicitly excluded (Is softdeleted = 1). For BIRT reports, there is a checkbox when you are displaying the report that allows you to select if you want to see deleted records or not.
It would be a good idea to verify the DW to ensure the records are in fact marked as deleted (ISSOFTDELETED = 1). If they are not, then check the ETL's. Ensure they had run successfully after the changes were made in the application.
Thanks,
Clara
What tool are you using to create the report? RRDI has a general parameter to determine if deleted records need to be shown or not. Also, when creating the queries sometimes the verification is done only on the source table, therefore the deleted records in the target table need to be explicitly excluded (Is softdeleted = 1). For BIRT reports, there is a checkbox when you are displaying the report that allows you to select if you want to see deleted records or not.
It would be a good idea to verify the DW to ensure the records are in fact marked as deleted (ISSOFTDELETED = 1). If they are not, then check the ETL's. Ensure they had run successfully after the changes were made in the application.
Thanks,
Clara