I have a dashboard prompt with various fields to allow the client to filter the data by year, quarter, month.
I have my own development environment and when I test the prompt in my OBI server everything looks fine. But when I deploy the prompt in the client environment something weird happens: the NULL value appears as an option in the choice list.
Any clue about why could this happen?
Your prompt is populated by a query. That query accesses the database. If your query returns a NULL and the query is the same in both environments that means that your database is the place where there's a difference.
a) Grab the two queries from both environments b) Run both queries against their REPSECTIVE databases c) Compare the results d) Run both queries against the OTHER database e) Compare the results
If the doesn't show you where the error source is, then your prompts are different and you made the error while configuring things in the front-end or the RPD and they are not as you say identical.