How to hide a dashboard dynamically in OBIEE?

Below are few thoughts / solutions on how to hide a dashboard dynamically based on day of the week etc:

1) This will work with the help of JavaScript and Conditional Section Guided Navigation. You need to create a table with FLG col, with 2 values 'Y' & 'N'. When dashboard is visible..FLG value will be 'Y' and when you want to hide then 'N'. You need to schedule an ibot to change the flag value dynamically at scheduled time.

2) Guided navigation. Create a report which return no rows on the day you want to hide it. on the dashboard page use this a source to show the other report (section properties).

3) I think you could hide it dynamically by swapping out the .atr files which control the dashboard permissions.

You would need to do the following...

1. Create the dashboard
2. Copy the .atr file somewhere else temporarily
3. Change the dashboard permissions so it is not visible
4. Again copy the .atr file somewhere else temporarily
5. Write a script that swaps these files over depending on the day of the week
6. Schedule the script to run using cron job or windows scheduler

Until Next Post... :)