Gurus.
I believe this must be pretty common requirement across projects. I want to display a meaningful message when the report is run. Here is the scenario for e.g. My data load for the last night failed for whatever reason and as a result the data marts doesn't have the yesterday's data. Let's take a scenario that one of the user is running the daily summary query for date between today and beginning of month. Considering that the report is still meaningful for aggregate data for each day except the missing data from yesterday, I would like to run the report but also show the message that the data is not current before the report in run.
Please let me know the most effective way to achieve this. I have thought about a couple of options but not sure if those are the most efficient ones. Would like to hear from you as how you would address this efficiently?
I believe this must be pretty common requirement across projects. I want to display a meaningful message when the report is run. Here is the scenario for e.g. My data load for the last night failed for whatever reason and as a result the data marts doesn't have the yesterday's data. Let's take a scenario that one of the user is running the daily summary query for date between today and beginning of month. Considering that the report is still meaningful for aggregate data for each day except the missing data from yesterday, I would like to run the report but also show the message that the data is not current before the report in run.
Please let me know the most effective way to achieve this. I have thought about a couple of options but not sure if those are the most efficient ones. Would like to hear from you as how you would address this efficiently?