Custom Static Values with Optional prompt

[system]

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]

Optional universe prompts are not supported.

---

Nick Daniels (BOB member since 2002-08-15)

[system]

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]

Hi,

These two entries in the Designer’s FAQ will help:

120×120 10.4 KB

Is there any way to set up a prompt that will allow a user to select one value, many values, or type ‘ALL’ for all values in a list? Yes. Below is a sample of the syntax required to allow a user to select one, many, or all values from a prompt. (@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR ('*' in @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Co…

120×120 10.4 KB

Now that my LOV lets me use ALL for all values, how do I get the ALL in the list? Author: Dwayne Hoffpauir There are two approaches - overriding the LOV SQL, and creating a universe object. Overriding the LOV SQL Press the SQL button in the query panel of the LOV Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FRO…

---

Marek Chladny (BOB member since 2003-11-27)