Selecting object in prompt can we do this

[system]

Web i in Xir2
here is my scenario
If i open a report
it should prompt me asking for to choose one of two options(objects in Universe)

1. Employee ID
2. Sales Person ID

and
if i select say Emplyee ID

employee ID equal to Total ID

or if i select say sales person ID

Sales Person ID equal to Total ID
and run the query

i am not able to go froward on this one?? any advice please?

---

arjunanand (BOB member since 2007-08-30)

[system]

You could look at this link…

120×120 10.4 KB

Hi Friends, I need a help in WebI report. It would be great if someone provide me a solution. I have a prompt in WebI report. So, based on the prompt selection we need to have filter in the report. For ex: when I have prompt A/B, then if A is selected then I need to display the filter in report A=1. I tried the option creating filter at the universe : Case @Prompt(‘Select a Metric to display’,‘A’, {‘A’,‘B’},mono,free,not_persistent,{‘A’}) when ‘IMS’ then class.A =‘SE’ else class.B =‘ME’…

Not your exact scenario but you could do it this way. As a start, prompt the User to chose one of “Employee ID or Sales person ID” (just the texts). Based on the UserResponse, build your where clause.

---

nithya_raj (BOB member since 2007-02-03)