I want to start using Cached Datalayers for our daily sales snapshot, which look straight forward and easy to use. However, I have a question about deleting a cache if required.
Here's the scenario: -
Our data warehouse is updated and built overnight so that the tables etc are ready for reporting by 6am. Of course, there could be errors with the build or delays for whatever reason.
At 6:15 a branch runs their MTD Sales Snapshot, which will not change until the following day when the warehouse gets updated again. As every branch user will view the report as they startup it makes sense to cache the queries. So, if the cache(s) are set to expire at 6am then the first staff member to run the report will force a requery and recache whilst everyone thereafter will use the latest cache. All good.
But, what happens if the overnight build is delayed for some reason? After 6am the first user will force a refresh but the data will be incorrect because the build is still happening. But, now the cache has been generated so how can I force a refresh?
Ideally, I should be able to create a task that I can run which kills all the cached reports or updates the cache time. Even better would be for the report check the build and force a refresh of the cache.
Please sign in to leave a comment.