Adding ALL to LOV or "ALL" Prompt Value in Business Objects

In this topic, we will discuss about "All" value in prompts.

This is the most frequent scenario, which comes across Business Users and developers, why this option is not available in BO. It is till XI R2. But in XI R3.1 SP3 it got little push-up. Even though, its not yet upto the mark when it comes to implementation in Universe Designer.

Let's take an example. There is a Region dimension object which contains values as "INDIA, CHINA, US, JAPAN, MEXICO".

When we define a prompt object, user can select one or multiple regions. If the user wants to select all regions, we must select one by one and pull it into required list of regions. To avoid that, if we have an "ALL Regions" or "ALL" or "*" option to consider all regions in report, that would make Business Users easier.

1.  Create a conditional object.
2. @(Location\Region) = @Prompt('Select Region','A','Location\Region',mono,free,Not_Persistent,, user:1)
3. The above condition is defined in general if we want to allow users to select one region from list of available regions. 
4. Now we will incorporate "ALL" option here.
5. @(Location\Region) = @Prompt('Select Region','A','Location\Region',mono,free,Not_Persistent,,user:1) or "ALL" =@Prompt('Select Region','A','Location\Region',mono,free,Not_Persistent,,user:1)
6. We just added a additional expression  or "ALL" =@Prompt('Select Region','A','Location\Region',mono,free,Not_Persistent,,user:1). 
7. This expression is added with an OR clause. This condition is valid when the user provides "ALL" as input value. 

Keep watching this space. Will come up with more interesting topics!