Skip to Content
0
Former Member
Mar 18, 2014 at 09:11 PM

Restrict LOV to return values to specific table

28 Views

Hello,

I have a requirement in universe where I have to restrict the LOVs to certain tables.

I have a field "Contact" from contact_table" in the universe. This field I am using in webi report prompt and it shows so many list of values.

There is a field "Contact_ID" in another table "Sample"table in the universe. How do I restrict the contact object to return lovs in relation with possible values of Contact_ID in Sample Table?

Thanks,

Nisha