Cognos Vs Business Obejcts

[MrCognos14]

I need to do the following custom filter in a report for Cognos. But in Business objects looks like this:

@Select(LE Entity Corptax\LE Corptax Code) IN @Prompt('Enter entity corptax or entity label','A','LOV LE Entity Objects\Corptax Code',multi,free) OR @Select(LE Entity\LE Entity Label) IN @Prompt('Enter entity corptax or entity label','A','LOV LE Entity Objects\Corptax Code',multi,free)

OR

LE Corptax Code IN @Prompt('Enter entity corptax or entity label','A','LOV LE Entity Objects\Corptax Code',multi,free) OR LE Entity Label IN @Prompt('Enter entity corptax or entity label','A','LOV LE Entity Objects\Corptax Code',multi,free)


@Select is a simply a reference to a table name.
@prompt ('prompt text (1)', 'type (2)', 'list of values(3)', 'mono/multi(4)', 'free/constrained(5)')
@Prompt BO: Please click this link to find out more

http://business-objects-xi.blogspot.com/2009/06/prompt.html

Thanks anyone who could help regarding this issue !

 

[blom0344]

Cognos? Are you talking about Report Studio?

If this is just a single report implementation, then you would do the following:

Define a value prompt within report studio and make sure this is a multiselect one. Associate a query that builds the list of values to be selected and assign a parameter like 'Corptaxcode' to te prompt.

With data queries you can now add a filter that references the parameter 'Corptaxcode' like:

[LE Corptax Code] in ?Corptaxcode? or [LE Entity Label] in ?Corptaxcode?

Ties Blom