Limiting LOVs in Prompt depending on the Context used

[mhmohammed]

All,

Can we restrict the LOVs of an Object depending on the Context the Query selects?

I've a prompt on the object Sub Division Code & Name which has 414 distinct values, but I want to limit the values for that object when the query is run against Context A as the Fact table has data only for 50 of those values.

Is it possible?  Please help.

Thanks,

M Mohammed

[Former Member]

Hi Mahboob,

You cannot limit the number of records on basis of context. The limitation could be applied at universe level.

Regards,

Yuvraj

[Former Member]

You cannot dynamically switch list of values.

An idea though:

You could, however, create a dummy object in a hidden class and build a list of values to reflect the fact table contents (edit your LOV query to achieve this).

Then you could associate that LOV with a predefinied prompt condition where you can restrict the fact table rows based on the values from the hidden LOV.