The dimension “Contract Days Remaining”; uses a relative date function getdate() to compute it’s value. The getdate() function will change in value each day:
datediff(day, getdate(), (CONVERT(VARCHAR(10),renewal_date ,120))) AS "contract_days_remaining"
Because this figure changes everyday, should we schedule a report that contains this dimension using “and results changed since last run”, then the report is sent every day. We have no way to schedule a report to be sent but only when new data has been added to the DB.