[V6.5] prompt with optionnal filters

[system]

Hi Sokhar,

In your BO version, you can simulate the optionality of a prompt by so called “ALL in LOV” concept. Basically, using one technique you add one additional value into the LOV. The value will be something like “-- All --”. Then if users selects this value from the LOV of a dimension then the condition will select all possible values of the dimension, it means it will work as there is no condition for the dimension.

Check these 2 entries in the Designer’s FAQ:

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)