Currently i am facing a weird issue in Dashboard prompts of OBIEE 12c.There are invalid Null values that are not present in database but showing in prompt columns in OBIEE. For some of the columns Null Values is valid but for other it is not. So Business wants to display null value in prompt only if it is valid and appears in DB column as well.
There are two ways to fix this issue,
a) edit this prompt and check the ‘Require user input’ property (doesnt work max times)
b) At RPD level , uncheck the Nullable option under the physical column as shown below:
Then restart / recycle all the servers. Untill then this change wont get impacted. Do it for only necessary columns which will never have NULL value in DB also.
Follow for more on my FB page
or my OBIEE group