Analytics Software

I need to create a hyperion report which extracts records from a table whose update date is greater than the last report run date and time.

For example, if the report is run at 7.05 P.M on one day and if the report is run at 7.20 P.M the next day, the report should extract all those records from the table whose update date and time is greater than the last report run date(7.05 P.M the previous day). The report needs to use query.

Could you please let me know how this can be implemented.

i. Can the report save the report run date in a table and then retrieve the date from the table when the report is run the next time.

ii. If we set the date as a parameter to the query, each time we execute the query we need to pass the report last run date. Is there any scheduler table which stores the run date of each report which can be used.

Thanks in advance.