on 03-22-2016 5:40 PM
Hi, I have created Universe prompt for LOV’s to select. And wanted implement ALL thru Universe prompt, instead of Optional prompt in WEBI, where you can leave without giving anything. So, here user wanted to choose ‘ALL’, so that it returns everything. This is my syntax. However, it shows ‘All’ but does return empty. database is SQL Server STATE=case when @Prompt('Prompt Text','A','LOV\STATE',Mono,Free,Not_Persistent,{' '})='ALL' then STATE else @Prompt('Prompt Text','A','LOV\STATE',Mono,Free,Not_Persistent,{' '}) end
Hi Cristina,
Below are the steps you need:
@Select(Store\State) IN @Prompt('Select State(s):','A','Store\State',multi,free,Not_Persistent)
OR 'All' IN @Prompt('Select State(s):','A','Store\State',multi,free,Not_Persistent)
Now, on creating a report with this prompt, result will show all states data in report when we don't select any State(s) or else, report will show data for whatever State(s) selected.
Hope this helps.
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cristina,
How about refreshing them in the Universe and checking the options "Automatic refresh before use" and "Export with Universe " in the 1st image I've in my earlier response. And you can use the option for Caching LOV's (from CMC), per this post https://scn.sap.com/thread/1369294.
Thanks,
Mahboob Mohammed
Hi Cristina,
The steps don't change, it's just you'll have to go to different places in IDT. This may not be in detail.
Voila.
Thanks,
Mahboob Mohammed
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.