How can i restrict the LOV based on the selection made .
For example i have two objects plant name and plant number in class plant
I have query filter on Plant number and have value 1
I need the next prompt in the query filter on plant name whose LOV should show only names pertaining to Value 1
I dont want user to enter plant value as i a developer i will hard code it he will have only choice to select plant names under plant number 1
In the similar way if in the second report I have filter on plant number and have value 2 I need the next prompt in the query filter on plant name whose LOV should show only names pertaining to Value 2.
so my question is how can acheive this at the query filter in webi.?
cascading prompt will serve my purpose but the problem if i create a cascading promt something like enter plant number and the then it will ask enter plant name but i want to hardcode plant number , which i can do at universe level had it been only for one plant number
but i have 8 plant numbers so how can i make this happen?
I want something like one filter on plant number and based on that selection a prompt on plant name?
Can i change the prompt sql at the wbi query to accomdate this,if yes what changes i need to make to the query