Sunday, 6 January 2013

OBIEE11g: "NULL" Value in Prompts (NULL is showing as a value in the Prompts) or Removing NULL value from Prompts

Hi All,

In OBIEE 11g when we create a prompt on a column we can see "NULL" value is in the prompt. As it is the unwanted value we have to suppress this value. We can achieve this by following the below steps...

Step 1 : NULL is getting displayed in the Prompt

Step2 : Edit the prompt and look for the column on which the prompt is created

Step3 : Open the RPD in Online or Offline mode. Go to the physical layer and select the table, expand the table and select the column



Step 4 : Edit the properties of the column by double clicking on it.


Step 5 : Unchecked the Check box which says "Nullable" as follows



Step 6 : Save the RPD and check the same on the dashboard. Now you can see the NULL value got disappeared.

NOTE : After saving the RPD changes it will take some time to reflect the result on the dashboard. Immediately you can not see the NULL value disappeared. It will take about an hour or so to reflect if you make the changes in Online Mode. If you restart the services then you can see the immediate expected result.
After making the changes in Online mode and saving it dont forget to clear the cache.

Posted by at

4 comments:

  1. Unknown28 March 2014 at 13:41

    Thanks for providing such real time scenarios in your blog.Very useful.Please keep posting!!
    Could you please post more info regarding MUDE? Is there any way that we can get the previous version of RPD in MUDE environment? Please share more info related to version control or history tab in MUDE?

    Thanks

    ReplyDelete
    Replies
    1. FAAHON BEAUTY & HEALTH1 September 2017 at 20:38

      Hi there is also one more possible way
      go to Options
      Choice List Value- coose sql result

      default sql will display example

      Select "Time"."Fiscal Quarter"-----table name
      from "Financials - AP Overview"----subject area


      modify the sql as

      Select "Time"."Fiscal Quarter"
      from "Financials - AP Overview"
      where
      "Time"."Fiscal Quarter"= VALUEOF(NQ_SESSION.CURRENT_FSCL_QUARTER)
      where "Time"."Fiscal Quarter" IS NOT NULL


      ---and save the prompt

      Delete
    2. Venkata Nagarjuna1 September 2017 at 23:21

      Hi Vivek,

      Thanks for sharing your views here.

      Thanks,
      Nagarjuna

      Delete
  2. Unknown4 January 2019 at 01:43

    Vivek while your solution would remove the Null value , you would end up losing the "limit by" option.

    ReplyDelete

Subscribe to: Post Comments (Atom)