LOV Issue

building semantic layer
1

Dear All,

I have an Object called OrderNo, the sample values are given below:

OrderNo

11
12
13
14
15
16
17
18
19
20

The above records are appearing in the report, however few values are not appearing in the LOV. I have deleted the Object and created new Object in the Universe but LOV issue is still there, I really surprised. Anyone can you help on this issue?

Thanks in Advance.

Warm Regards

SivakumarS :singapore: (BOB member since 2006-08-10)

2

Did you try refreshing the LOVs?

Jansi :india: (BOB member since 2008-05-12)

3

Yes, I have refreshed the LOV in Univesre, Report. And I recreated the Object but no luck…

SivakumarS :singapore: (BOB member since 2006-08-10)

4

Is it a “standard” LOV or have you used your own SQL code to produce the LOV?

If all values are in the report then the LOV must be wrongly defined or propogated through. Have you looked at the possibility that it is not being exported with the universe?

5

Also please let us know where you are testing the LOV output. In Webi, large LOVs are “chunked” into pages. You may need to simply click the “next page” button to see the remaining values.

You may also be hitting the partial results issue; what is the total row count allowed for your universe? Can you get a list of all of the items in a report, or do you get partial results?

Dave Rathbun :us: (BOB member since 2002-06-06)