'ALL' option in LOV of a prompt to select ALL values in IDT 4.0

[former_member640919]

How to create 'ALL' option in LOV of a state prompt to selec t ALL values, so that to appear in Webi 4.0 prompt? We are using IDT 4.0.

[Former Member]

Hi Jaishree,

Are you still facing this issue? try this

SELECT

"state"

FROM

table state

UNION

SELECT

' All' state

FROM

"SYS"."DUMMY"

ORDER BY 1

Regards,

Mathivanan

[former_member4998]

Hi..There is no “ALL” value option include in LOV’s, if you wan to “ALL” value in the LOV’s you need to explicitly include in the LOV’s. By adding the custom code in the object WHERE clause.

Find the below link’s for more info.

Steps to insert "ALL" as a value in Object LOV to select all values in WebI prompt

http://scn.sap.com/docs/DOC-49751

http://scn.sap.com/thread/1201562

Sample code

SELECT DISTINCT

Customer.Country

FROM

Customer

UNION SELECT 'ALL'

FROM

Customer

how to bypass mandatory prompt screen to select * value in the list of values of the specific dimension.

http://scn.sap.com/community/semantic-layer/blog/2014/05/31/how-to-bypass-mandatory-prompts

sample code

SELECT Distinct '*' As AG_GROUP

From  "TABLE”

WHERE "TABLE”.”FIELD" = "TABLE”.”FIELD"

UNION ALL

SELECT DISTINCT "Specific dimension which you need to include * value in LOV’s" AS AG_GROUP

From  "TABLE”

ORDER BY AG_GROUP

[former_member4998]

Hi..Are you able to include "ALL" in the LOV's?

PLEASE change the question is Answered and blog as helpful & answered.

[former_member221178]

I came across a couple of issues while working on UDT.

I have opened the UDT-> opened the object prop for the obj I want ALL in LOV -> edited LOV -> viewed SQL and tried to give the sql query mentioned in the doc above. I tried ot save it but it just doesn't get saved and the object remains the same. I am not sure what I am missing here. I am still not able to see the ALL in the LOV.

My query is like, "SELECT DISTINCT object name FROM table name" and to this I just added "UNIONSELECT 'ALL' from dual" to it and then tried to save it. and then nothing happens.

Please advice.