Skip to Content
Author's profile photo Former Member

Prompts issues at WEBi Reports

Hi All,

We are connected to BEx Queries for our WEBi Reports (via connector/universe) and in BEx we’ve set up some variables i.e. Target currency via CMOD (Customer Exit).

These are then used in the WEBi query as Optional Prompts. Now the requirement is as follow…

1)    In the Target currency we have the data “USD”, “EURO” and “CNY”. But customer needs to see Target currency as only “USD” at Universe level. Please let us know how to restrict in Universe level.

2)    In the selection screen (Prompts) the Target Currency is as “USD” based on customer selections and the currency type “USD” should be display beneath of Report title.

          Example: The report name – Sales Register Report (USD)

Note: – We don’t have object like Target Currency and just we are having only Filter condition based on Bex Query Customer exit.

Target Currency Filter Condition below

<OPTIONAL><FILTER KEY=”[!V000003]”><CONDITION OPERATORCONDITION=”Equal”><CONSTANT TECH_NAME=”@Prompt(‘Target Currency’,’A’,’Target Currency\LovTarget CurrencyBase’,mono,primary_key)”/></CONDITION></FILTER></OPTIONAL>

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Zahid Yener
      Zahid Yener

      Ok. This is what you do. In WebI, you can catch prompt values entered by the user. There is a specific WebI formula called UserResponse()  for this purpose.

      How to apply to you case:

      =UserResponse("<Your Prompt Text>")

      Your Filter:

      <OPTIONAL><FILTER KEY="[!V000003]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="@Prompt('Target Currency','A','Target Currency\LovTarget CurrencyBase',mono,primary_key)"/></CONDITION></FILTER></OPTIONAL>

      ="The report name – Sales Register Report ("+UserResponse("Target Currency")+")"

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks for your response and it is working fine....

      I have posted two requirement 1 is solved and another one is as follow...

      In   1) The Target currency we have the data “USD”, “EURO” and “CNY”. But customer needs to see Target currency as only “USD” at Universe level. Please let us know how to restrict in Universe level. can you please share your ideas for mentioned Universe restrictions issue.

      Author's profile photo Amit Kumar
      Amit Kumar

      Hi,

      edit the object in universe and put the condtion in where clause.

      <FILTER KEY="@Select(Target Currency\LovTarget CurrencyBase)"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="USD"></CONSTANT></CONDITION></FILTER>

      then create condition on this object.Every time this object give you only USD as value.

      Or you can restrict object at Bex query level only so that no need to do any change at universe level.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Amit,

      Thanks for your reply...

      We resolved the issue by doing of activity at Bex query level.

      Rg,

      Raghavendra

      Author's profile photo Zahid Yener
      Zahid Yener

      What do you mean at the universe level? You are applying this filter on universe level already. The filters you define in Bex applies to whole universe. If you mean, you want your users to only select USD as target currency then you have to do it in Bex not in the Universe. In Bex, you should define your target currency as constant then. This way your universe only return USD currency as your target.