Problems with Prompts

[system]

I have a report that has a prompt for “Prodcut”. I have it defined as “in list” and “prompt list of values”. I want the user to be able to select from the values list any number of products. Is there a way to have an “all” option that would select all of them rather then the user having to select all the products individually?

Also, is there any limitation as to the number of such prompts the report can have? I have added 6 of them and when I select all of the values from each of the six prompts Webi seems to choke and does not do anything. If I just select a few from each it all seems to work fine.

Thanks!

---

d1cjm1 (BOB member since 2003-02-24)

[system]

@d1cjm1

I have a report that has a prompt for “Prodcut”. I have it defined as “in list” and “prompt list of values”. I want the user to be able to select from the values list any number of products. Is there a way to have an “all” option that would select all of them rather then the user having to select all the products individually?

Take a look at the Designer FAQ, or search for “prompt all values default” and you’ll see any number of topics discussing this.

Here are a couple of links to topics to get you started:

adding ALL to LOV in condition prompt - easy?

Hi everyone, I did do some searching and browsing through a number of pages on this board, but didn’t see anything that answers my question, which is surprising, because I’d think it’s something that many would wish to do. I have a list of values, lets call the object Site, with NYC and Boston. I’m prompting the user to enter a value based on this object. I wish to add an item ‘All’ so users do not have to multi-select everything to get everything. (most prompts I’d actually implement this…

Prompts: Default values

I am not quite sure if this can be done within BO or at a data level. We have some reports where the user will be able to select the month he wants the see through the use of prompts. We want to be able to set the default value to the current month. I know you can set the default value in Designer but it would have to be changed every month… I can’t think of any ways of doing this so any ideas would be welcome. Thanks in advance. Olivier Masse (BOB member sinc…

Also, is there any limitation as to the number of such prompts the report can have? I have added 6 of them and when I select all of the values from each of the six prompts Webi seems to choke and does not do anything. If I just select a few from each it all seems to work fine.

That’s not a webi issue, it’s a database issue. By selecting all values from 6 different prompts you’re giving your database quite a chuck of data to process. 8)

---

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

[system]

Be warned, though, that if you use the standard way of implementing this (…or ‘all’ in …) that you will bypass any indexes on that field in the DB if the users select ‘all.’ This might affect performance.

I would advise thorough testing.

Judy

---

JMulders (BOB member since 2002-06-20)

[system]

One of the customer support engineers here received this solution from Business Objects.

PART_NOLOCK_V.customer_pn_S IN
(CASE WHEN
@Prompt(‘Customer PN: (or type all to see all)’, ‘A’, ‘Plexus Part UDAs\Customer PN - Assembly Number’, multi, free) = ‘ALL’
THEN PART_NOLOCK_V.customer_pn_S
ELSE @Prompt(‘Customer PN: (or type all to see all)’, ‘A’, ‘Plexus Part UDAs\Customer PN - Assembly Number’, multi, free)
END)

This approach preserves the use of the indexes.

• Judy

---

JMulders (BOB member since 2002-06-20)

[system]

That’s a great one!

Any confirmation from our resident Oracle guru’s would be appreciated.

---

Steve Krandel (BOB member since 2002-06-25)