BusinessObjects Board

Getting 'ALL' or '*' into LOV problem

building semantic layer
#1

Hi all,
I’m tring to get ‘*’ to show up in a LOV by overriding the LOV SQL. I’ve got it working if the LOV data type is char but not if the data type is numeric.

SELECT DISTINCT
to_char(GASVALVE.GASVALVETYPE)
FROM
GASVALVE
union select ‘*’ from DUAL

generates the correct LOV in Designer when I click the Display button.
i.e.

1
2
3
4
etc

however when I try and use the LOV in Webi, the LOV shows (–No Value–). Any tips on how to get ‘*’ or ‘ALL’ into a LOV consisting of numeric data types?

Thanks
Keith

KeithL :australia: (BOB member since 2008-02-18)

#2

hi

the above link will help you.

thankyou
judia

judia (BOB member since 2008-06-24)

#3

Thans for posting judia but I’ve successfully used the override LOV sql method, outlined in the FAQ you linked to, for universe objects that are of character datatypes. Using the exact same method fails if the objects are a numeric datatype. I’m not sure if I have to do anything extra in this scenario.
Cheers
Keith

KeithL :australia: (BOB member since 2008-02-18)

#4

A simple search found this… :slight_smile:

https://bobj-board.org/t/76564

Mak 1 :uk: (BOB member since 2005-01-06)

#5

Thanks Mak 1 ( I did do a search before posting, I swear :lol: :oops: )

KeithL :australia: (BOB member since 2008-02-18)

#6

hi keithL,

i have understood what you are trying to say.
kethiL, since you are using a measure object, you have to unite with only measure object.
ex: union select 0000 from dual

this may help you.
try

judia

judia (BOB member since 2008-06-24)

#7

Thanks all. It works if I do the following

SELECT DISTINCT
(GASVALVE.GASVALVETYPE)
FROM
GASVALVE
union select -1 from DUAL

KeithL :australia: (BOB member since 2008-02-18)

#8

That’s great KeithL!!!

judia

judia (BOB member since 2008-06-24)