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>