BusinessObjects Board

Prompt question

building semantic layer
#1

How do you create a prompt in Designer on a filter that will allow the user to select one or multiple values, or “All” from the list of values? The syntax that BO provides from their website does not work:

Example - This syntax is from the where portion of the filter in the Universe:

crmsurvey_dbo_crm_employees2.cn IN @Prompt(‘Message(type ALL for all values)’,‘A’,‘Filters\Cust Rep CN Filter’,) or ‘ALL’ in @Prompt(‘Message(type ALL for all values)’,‘A’,Filters\Cust Rep CN Filter,)

When this is run, the syntax check comes back as OK, but the does nothing when the report is refreshed… Any ideas?? :confused:

robbie :us: (BOB member since 2003-02-24)

#2

Check out our Designer FAQs.

Cindy Clayton :us: (BOB member since 2002-06-11)

#3

Cindy - thanks.

This may be a silly question - Where should this code be placed? Within the where clause of the object?

Also, does it matter whether or when you use the table/fieldname vs. the class/object inside this code?

robbie :us: (BOB member since 2003-02-24)

#4

This code should be places in a condition object. Condition objects only have a Where section.

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

#5

You use CLASS/OBJECT if you think this source object will change over time. Then if you change the SOURCE object, all other SQL built on this object will change accordingly. This is good if you base a number of objects off another object. (Like segments of a Campaign Code that could break down into other “aspects” of the campaign (compound keys)).

You can use the TABLE.FIELD if your database is relatively stable and this is the only use you will have for this field.

-RM

digpen :us: (BOB member since 2002-08-15)