Trying to create a webi report/dashboard on a transactional based database. The data refreshes 3 times a day (8am, 3pm and 5pm). I want to build a report/dashboard in webi that will:
A) refresh automatically based on the above times
B) Display a message box that report/dashboard is currently unavailable due to database refresh if the report is run at above times, also if the report is run at above times, the query should not go to database.
Any ideas or suggestions? Appreciate the help and feedback.