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?