ALL thru Universe prompt

[Former Member]

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

[mhmohammed]

Hi Cristina,

Below are the steps you need:

• Update the State LOV to add 'All' to the list.

• Create a Pre-defined filter on State with the following SQL in Where clause. Note: 'All' in the below SQL should be exactly similar to the text we added in SQL for LOV of State in previous bullet (snap 3).

@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

[Former Member]

Works fine, But 1 minor concern is that I have to click manually 'Refresh values' every time in Webi Report. why its not showing the values when I refresh.

[mhmohammed]

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

[Former Member]

How would I Achieve same using IDT?

[mhmohammed]

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.

• Update the State LOV (that is associated with State object, if no LOV is associated, we'll have to create an LOV and then associate it)

• Save Business Layer
• Create a Pre-defined filter with exact same text as my first post.

Voila.

Thanks,

Mahboob Mohammed

[mhmohammed]

Hi Cristina,

Please mark Correct Answer if its answered. Others can use the steps in this discussion if and when needed.

Thanks,

Mahboob Mohammed