BusinessObjects Board

Use of InList and Matches Pattern in a single prompt condit

building reports desktopintelligence
#1

The report is a sales report for items. We divide items into product groups. So say for example I have CBL which is a product group for all Cable products, NET is a product group of all network products.

Part to Product group is 1:1

I want the report to allow the user to enter either Product Group or Items ans also allow them to use Values from LOV or enter a wild card for all.

So I have two prompts:

  1. Product Group IN list Prompt (‘Select Product Group from Values’)
    AND
  2. Items Matches Pattern Prompt(‘Select Items or use % for wild card’)

Scenario 1: I want to run report by entering Poduct Group: This works fine, I type or select a Product Group, and since Items is matches pattern, I can enter % for all (Oracle)

Scenario 2: I want to run a report for all Items that are like ‘H7g%’

I cannot do this since Product Group uses In List. Is there a way to use a radio button kind of selection, where a user is either selecting a Product group or entering item pattern?

OR be able to say:

PRODUCT GROUP MATCHES PATTERN OR IN LIST (in a single condition) and not in two separate conditions

I know it can be done by VBA, but I want to avoid writing extra code if BO has something built in…

Thanks

chiragk :us: (BOB member since 2003-10-22)

#2

Create one prompt “Option” to get “Product Goup” Or “Pattern”(G or P)
so you condition should be like this

Product Goup IN (DECODE(@Prompt(‘Option’…),‘G’,@InlistPrompt,’’)
or
Product Goup Like (DECODE(@Prompt(‘Option’…),‘P’,@InlistPrompt,’’)||’%’

Hope it would help

Shahubar Sadiq :india: (BOB member since 2003-02-28)

#3

Once you have prompts they must be filled out with some values.

You have two options:
A) Use VBA
B) Use the ALL trick for prompts, see this post in FAQ Designer

Andreas :de: (BOB member since 2002-06-20)

#4

I do not understand how the Option prompt can be created… Is it a user object? If so what is the formula?

Guess I am kind of confused.

chiragk :us: (BOB member since 2003-10-22)

#5

you can create as filter condition
Designer --> Insert --> Condition

Good luck

Shahubar Sadiq :india: (BOB member since 2003-02-28)