This content has been marked as final. Show 6 replies
I experienced the same issue in 22.214.171.124 and it was working fine in 126.96.36.199. In the physical layer of the repository there is a column attribute "nullable" - with this attribute checked I was seeing "NULL" in the dashboard prompts. After unchecking "nullable", I no longer had this issue.
Thank you, Paul
In the dashboard prompt, you can check the "Require user input" option to remove this NULL value from the value list.
Alternatively, for the "Choice List Values", instead of using All Column Values, use SQL Results to explicitly excluding NULL. For example:
SELECT "Year"."Year" FROM "BM" WHERE "Year"."Year" IS NOT NULL
Go--> Physcial layer-->extarct your table--> double click your prompt column--> check nullable.
GO--> your prompt-->Show-->sql results--> SELECT your column name FROM your subject area where your column name is not null
Hopt it help's
This bug workaround does not work in all cases. I have unchecked the 'NULLABLE' option in the physical layer, but I still get the NULL value. Interestingly, the problem is not in the SQL that is being sent to the database. It is quite ordinary, and returns the correct results. The NULL is something that OBIEE is adding after the fact.
Neither can I use the Logical SQL, because I want this prompt to cascade, i.e. I want to use the Limit values to All Prompts option, which is unavailable when using SQL Results as the dropdown type.
Edited by: Mark T. on Dec 26, 2012 9:16 AM
I would like to correct my previous post. After I restarted the BI Presentation Server, the extra NULL value in the prompt did indeed disappear.
I had the same issue.It does not show all the valid values.The moment i uncheck the "Limit values by" then it start showing all the valid values in Prompt.