on 09-03-2013 10:48 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.