cancel
Showing results for 
Search instead for 
Did you mean: 

Optional in @prompt function

Former Member
0 Kudos

Hi,

I have created an optional  filter using @prompt function @prompt('Parameter Name','A','LOV',Mono,constrained,not_persistent,,User:1,optional). But it show below error while refreshing the report.

Database error: ORA-00936: missing Expression.(IES 10901) (WIS 10901).

can we provide "optional" in @prompt function.

Thanks,

Sathish

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Satish,

As Mark mentioned, optional prompts are supported only with olap universes. Please refer the below KBA:

1428724 - How to create an Optional Prompt in Universe Designer

Regards,

Madhumitha

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sathish,

Please look into this page for optional prompt in universe,

http://scn.sap.com/community/semantic-layer/blog/2013/05/24/optional-prompt-in-bo40

Regards,

Ambreen

Former Member
0 Kudos

Universes generated from OLAP sources support optional prompts but you'd have to define your prompt at the report level to make it optional. At least that's the case in XI3.1, it may have changed in BI4.x