Input data to Webi report

[scott_golonka]

This is my first time posting here so please redirect this to the proper board if needed. I was not able to find one specifically for BO/Webi.

I have a webi document that is 2 queries merged on a product ID. It is a sales report that is displaying objects from the universe and some user created variables that are performing calculations. There is one piece of data that is needed in the report that is not available in the universe and it is only for certain products and the product could change each time they run the report (monthly). I created a user input that allows me to enter a value and save it to a variable to be displayed in the report. The problem is it is displaying for all products. I tried creating another user input to select the product but that just filters the report to that selected product.

Is there a way to display the amount entered into the first user input for only the product selected in the second user input?

Also, I just realized that while my product selection input is a multi-list my first input only allows for a single amount to be entered. Is there a way to enter multiple amounts to be linked with multiple games (i.e. $500/ Product 12345, $750/Product 54321)?

Update:

I have a webi document that is 2 queries merged on a product ID. It is a sales report that is displaying objects from the universe and some user created variables that are performing calculations. There is one piece of data that is needed in the report that is not available in the universe and it is only for certain products and the product could change each time they run the report (monthly). I created a user input that allows me to enter a value and save it to a variable to be displayed in the report. The problem is it is displaying for all products. I tried creating another user input to select the product but that just filters the report to that selected product.

Is there a way to display the amount entered into the first user input for only the product selected in the second user input?

Also, I just realized that while my product selection input is a multi-list my first input only allows for a single amount to be entered. Is there a way to enter multiple amounts to be linked with multiple games (i.e. $500/ Product 12345, $750/Product 54321)?