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>
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")+")"
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.
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.
Hi Amit,
Thanks for your reply...
We resolved the issue by doing of activity at Bex query level.
Rg,
Raghavendra
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.