on 02-24-2016 7:51 PM
This is a possible universe setup issue. When using Webi (either rich client or InfoView) in BO XI 3.1, when a user adds a filter for a certain set of objects an entry appears at the top of the list of values that says [EMPTY_VALUE]. I suspect that this was setup to capture those records with blanks and/or nulls in the field. Unfortunately whoever set this up also put some HTML code in it, which causes the query to fail (see attached).
If I look at the object's list of values entries from within UDT this [EMPTY_VALUE] entry does not appear, I just see a blank line at the top.
How can I find where this is set up? No one at my company seems to know.
Hello Kieth,
Do you want user to only Select values that are available from list or they can have values other than the available options.
regards
Niraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Keith
Looks like you got an empty String "" as a value in your supplier dimension. An empty String seems to be treated as [EMPTY_VALUE] and be included in your WHERE clause of the generated SQL query to refresh the report.
Your SQL should look something like: [...] WHERE SUPPLIER IN ("")
Please check your generated SQL in the WebI report and make sure that your empty entry for supplier is valid. Should there be an empty entry for supplier at all in your dimension?
regards
Florian
Hi Keith
In the WebI prompt any empty String "" will be displayed as [EMPTY_VALUE]. I guess to show the user a comprehendable text instead of an empty value, which would not display anything. The generated SQL is correct and will display the suppliers with the name of an empts String.
Anyhow, I would recommend to remove the empty Strings from your file or database table. As I mentioned earlier, what is the purpose of having a supplier with the name ("")?
hope this helps
regards
Florian
Hi Florian,
My problem with the [EMPTY_VALUE] string is that when it is selected the value that is used is:
<font color=gray>[EMPTY_VALUE]</font>
When this is used with the In List operator the SQL fails. I want to find where this is stored so I can remove the HTML code. You can see this in the attachments I put on the original discussion.
Thanks,
Keith
Hi Keith,
My suggestion is to edit the LOV of the object to remove nulls so that there wont be chance of selecting this null and getting EMPTY_VALUE string in your HTML code.
Right Click the Object--> Properties-->LOV--> Edit --> SQL --> select distinct supplier name from table
where supplier name is not null or supplier name <> ""
--> check the option "Do not generate SQL before running"
Save and export.
This will avoid showing null values in LOV of your prompt
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.