Quarterly report --Change in Personal name/Company name

[geethkal12]

Hello All,
I have to create the report and got the package published already.
The reporting requirements are:
If the personal name has been changed within the reporting period; or
registered company name has been changed within the reporting period
then i have to provide id, code, previous personal name/company name, new personal name/company name and date the name changed.

Pleas anyone give me some idea how to apply the logic
Thanks
Divya

 

[toddl]

What does your data look like? Does your database track slowly changing dimensions in way that allows you to do this?

For example, some of our dimensions we only care about the current value, so we wouldn't be able to track this type of change.