Hi Gurus,
Due to huge data volume, we are using 2 UIDs as parameter Value in our report filter.In our Database, the UIDs get refreshed daily. Due to this, I need to clear the report cache everyday before the scheduled report runs so that the parameter value gets replaced by latest value from database.
Users have created report views and they run the views by scheduling job. Users do not want to create a report cache job to clear the cache. My question is, if I create a report cache job for that report and schedule it to run before the "report view jobs" run, would it also clear the cache from the "report views"? Or it just works only for the "report jobs" and not "report views"?
Please throw some light on this. Thanks in advance for your help and guidance !!!
Any help is really appreciated. Thanks