Oprional Prompt not working when no value is selected

[Former Member]

Hi Experts,

I am using Live office connectivity.

I have a optional promt. It is retrieving the records when some value is selected.

But if i dont select any value(as this is an optional prompt) it is not retrieving any records.

I have tried using Not Assigned and # also but those options didnt work in my case.

Pls help me in solving this issue.

Thanks & Regards,

Bhargava Bommidi.

[Former Member]

Hi,

You actually need to pass <Not Specified> to an optional prompt

[Former Member]

What are you passing values to? SAP BW? Test in your query what NULL gives. You may have to pass 0.