How to Replace the Null Value in Prompt on OBIEE 11g
I have seen several posts in OTN for how to replace null values in prompt.
1.- Validate if NULL values are relevant for the business analysis (for some reason in the data warehouse NULL values were stored). If they are not, you have to delete them in Dimensions and Fact tables.
2.- Change the physical table type in your rpd in all tables you have NULL values and use a SELECT like this:
SELECT LOGIN, RESP
WHERE NOT LOGIN IS NULL
Doing this, you only have NON-NULL values in your Multi-select prompt.
3.- Replace the NULL value with a new name like UNSPECIFIED in ALL tables you which are related.
4.- Log an enhancement request to review that multi-select prompts works with NULL values.
5. This is a knows issue. Check to see if your prompt list has a 'Null' value at the bottom. If Null value is selected in the prompt, it will wipe out the selection.
Instead of using "<<", try selecting all products using control + select and use "<" icon.
Satya Ranki Reddy