Skip to Content
Author's profile photo Former Member

WEBI report complex filters

I need some help on how to define the filter criteria in  WEBI. Out of two dates (sale date and shipping date) we have to control the user to at least enter one date. They can also enter both dates if they want. I tried with different combinations of AND & OR in between the dates. I can not make them both as mandatory. I have to make them as optional and make them to enter one date at least. Check if the user entered at least one date, if they do not enter one date, we should not let them execute the report. This I can achieve in the BEX report with no issues by placing user exit ABAP code in I-STEP 3 by giving a popup message to enter at least one date. Repeat the message till they enter at least one date. Same thing not sure how to achieve in the WEBI report. I placed the code for this in BEX and built universe out of it and WEBI report on Universe. The logic of the BEX is not working on WEBI report prompts.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Priya

      Make both the dates as optional in BEX and out of those two dates make one of them as "not ready for input" while the other as "ready for input."

      1.) In the BO Universe side, You apply an @Prompt function in the BO Universe on the Date variable which you defined as a "not ready for input" and you can design the report based out of that.


      2.) In the BO WEBI report itself you can directly pull in that Date which You defined as a "not ready for input" variable(ie. dimension in BO) into the Query filter section in the Query panel in Infoview/Launchpad.

      Then you will finally have one Date(which is set a ready for input in BEX) as optional Prompt and the other one date will be a mandatory one(which your are setting in the BO Query panel).

      Hope This Helps!



      Author's profile photo Former Member
      Former Member

      Hi Priya,

      I am also facing same issue. could you please explain how you managed it. Hope you are using BICS connection and not the universe.

      Thanks in advance,