system
#1
Hi
I have created a filter in the universe for custom static values with optional prompt.
Syntax validated in universe.
But, When I use this filter in the report without selecting value. I have an error message saying “Database error: ORA-00936: missing expression"
My Logic :
DIM_CATEGORY IN @Prompt(‘Select Category :’,‘A’,{‘Medicaid’,‘Health Insurance’,‘SHOP Employee’,‘SHOP Employer’,‘CHIP’,‘N/A’},Multi,Free,Persistent,Optional)
I’m using BOXIR4.0.
Any suggation please…
Madu (BOB member since 2008-02-08)
system
#2
Optional universe prompts are not supported.
Nick Daniels (BOB member since 2002-08-15)
system
#3
Thanks for the Information. Is there any work around to fix this issue…
I can compromise client to enter ALL insted Optional
May i know how can i create for ALL value.
EX : these are custom values for Object in (‘Medicaid’,‘Health Insurance’,‘SHOP Employee’,‘SHOP Employer’,‘CHIP’,‘N/A’)
or
ALL
Madu (BOB member since 2008-02-08)
system
#4
Hi,
These two entries in the Designer’s FAQ will help:
Marek Chladny (BOB member since 2003-11-27)