How to Grey out (Disable) selection of weekends and holidays in calendar prompt of OBIEE?

rajesh_obiee

I have requirement to Grey out (Disable) selection of weekends and holidays in calendar prompt of OBIEE.

Any Ideas?

Joel

Why don't you simply exclude them from the prompt?

[Deleted User]

You can't unless you rewrite the JavaScript behind that calendar. It's a calendar and what you consider "weekend" or "holidays" is something totally different in the nexr country over.

Martin van Donselaar

This in not out of the box functionality unfortunately.

Do you want to grey then out because it would result in no data? Or do you need to restrict the report from showing data on these days?

In the latter case you could create weekend/holiday indicators in your period dimensions to be ale to exclude weekends and holidays by using the indicators as filters in your analysis.

Gianni Ceresa

To summarize the previous answers, which are globally all right and cover the few possible ways you did your prompt the situation is simple.

Do you use the calendar-view prompt? (the one showing a real calendar)

If YES then forget your requirement at the prompt level, this visualization of the prompt doesn't support any option.

If NO then you have a normal drop down list with dates and you just need to change the prompt values to be the allowed dates instead of just any date (by using an attribute in your time dimension and filter on that).

If you are using the calendar-view prompt which doesn't give you any option you can:

A) try to code your own calendar view prompt in javascript => a nightmare job which isn't worth to be done

manage it at the dashboard level : your analysis must not return any date and show a message to select another date avoiding weekends or you can even have a condition in your page which hide the section with the analysis (so it isn't executed) and display another section instead informing the user of the fact weekends and holidays can't be selected and maybe even listing the holidays not being weekends (as not everybody know them).

So there you go and you got your answer ...