Limiting LOVs in Prompt depending on the Context used
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.