Web Intelligence Report on HANA database - Optional prompt

[nanda_veera]

Hi

We have a Web Intelligence Report built on top of HANA database and is having an optional prompt. This prompt accepts list of values.

This prompt is working fine when we pass values, but returning none when it is left blank(intended to display all users). Below is the prompt syntax used in the query.

(a.USERNAME IN @Prompt('User ID: ','A','/LOGWIN/EXT_LOG\Username',Multi,Free,Persistent,{'*'},User:1))

Did anyone had encountered the same?

Note: We have recently migrated Oracle database to HANA database.

Best Regards,

Veera.