Hi Friends

[Former Member]

I have a Requirement

In LOV and prompts right, How do we implement LOV such that users will not drag one at a time but ALL?

Please need some ideas,

Thanks in Advance

[Former Member · Accepted solution]

Hi Kavya,

If users wants to see all data you can create optional prompt, in this case if user doesn't fill any value for it by defalut all records will be shown in report.

And if user select few objects, he will be able to see data only for that.

How do we implement LOV such that users will not drag one at a time but ALL?

User can simply use CLT+SHIFT to select all and click on right arrow to execute report for all objects.

Regards

Shabnam

[Former Member · Accepted solution]

Firstly i thank for answer,but there should also be a way in edit list of lov's so that v can customise according to groupings from universe designer, i agree the way you proposed will match the requirement straignt forward what if for custom selection??, my concern is can v group it in edit lov?? in designer..

Thank you..

[Former Member · Accepted solution]

You can try creating Cascading Prompts, customization is possible in this case.

Please let me know if your requirement is different or explain with an example.

Regards

Shabnam

[Former Member · Accepted solution]

With the list of values, i should get  as All for the selection for promts.. so user can select all..

[Former Member · Accepted solution]

Hi Kavya,

Go to object properties >> Edit button >> View SQL button and modify the SQL

for e.g:

Select distinct table.column from table

union

Select distinct='All' from table

Thanks

[Former Member · Accepted solution]

Hi Prathamesh

          Your idea  worked up...

Thank you..

[Former Member · Accepted solution]

Hi Prathamesh

          Your idea  worked up...

Thank you..

[Former Member · Accepted solution]

Hi Kavya, please mark as 'Answered' if this works for you.

Thanks

[Former Member · Accepted solution]

Prathamesh in webi side am not getting any data in report,but in LOV All is appearing,i just made union as u said any other idea to club it...

[Former Member · Accepted solution]

Hi Kavya, what is the SQL generated by Webi report?

Thanks

[Former Member]

Hi prathamesh,

here is sql generated by webi..

SELECT

Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Yr,

Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.City,

sum(Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Sales_revenue)

FROM

  Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma

WHERE

Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.City  =  @prompt('Enter City:','A','Store\City',Mono,Free,Persistent,,User:0)

GROUP BY

Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Yr,

Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.City

Thanks