Prompts Question

[system]

Hi,
I’m having issues with prompts.
My users need a single report with all the prompt conditions on Dimension objects but the users should be have the option to skip few prompts while running the report.

Is it possibe to skip few prompts or can i put some default value (equal to null if they don’t insert any value in the prompts ) in the report.

I’m using XIr2 version on solaris.

Your response is greatly appreciated.

---

kumar23 (BOB member since 2007-05-25)

[system]

Optional prompts is one of the features in XI 3.0. However this is not the case in XIR2. You need to put a default value like ‘ALL’ in each prompt.

Refer to these links for more details :-

FAQ: Designer

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…

and

FAQ: Designer

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…

---

AnthonyJ (BOB member since 2006-06-30)

[system]

Combined with that, you could use the exytended syntax in XIR2 to ensure that the wildcard(either * or ‘ALL’) gets displayed by default each time the report runs by making use of the ‘Default value’ (In BROWN below) and ‘Persistence’(in BLUE below) portions of the @prompt syntax:

Eg:

@prompt(‘Enter Customer Name:’,‘A’,Customer\Customer Name’,Mono,Free,Persistent,{‘ALL’},User:0)

---

nithya_raj (BOB member since 2007-02-03)

[system]

THanks Anthony and Raj your respnse was very helpful to me.

---

kumar23 (BOB member since 2007-05-25)

[system]

I thought Optional Prompts would be available in XI 3.0 for all Universes, but I have only seen them in relation to OLAP universes.

Am I missing something, or do you have to use the same syntax as XIR2 to get around this common challenge?

---

snowboarder (BOB member since 2007-04-10)

[system]

I thought Optional Prompts would be available in XI 3.0 for all Universes

The extended optional prompt syntax does not parse in Designer .

Also, when run in Webi it does recognise it as optional but then throws an error, if you leave it blank.

The only way I could get this to work is by setting the prompts up in either the Java panel or Rich Client conditions panel and choosing the option in the prompts properties…

---

Mak 1 (BOB member since 2005-01-06)

[system]

Optional prompts are only available when built on the query panel. They are not yet fully supported in the universe. There have been reports that folks have managed to get the syntax working, but I would consider that a risky proposition. Business Objects has stated that they want to make optional prompt technology available via the universe but it’s going to be a greater effort than what it took to put them in the query panel.

I know it’s frustrating. We (the general user community) have been asking for optional prompts for a decade, at least.

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

There have been reports that folks have managed to get the syntax working

The syntax “works” / runs in Webi, however when you choose to leave an optional universe prompt blank Webi throws an error…

---

Mak 1 (BOB member since 2005-01-06)