Tuesday, April 2, 2013

Null value replace in Prompt

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.

There are four options to resolve this issue:

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
FROM NQ_LOGIN_GROUP
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.


Thanks,
Satya Ranki Reddy

No comments:

Post a Comment