BIP - Parameters

Card Puncher Data Processing

Predicates

Equal

If you use a parameter in your report, don't forget to use the NVL function in your predicate clause such as:

and e.employee_id = nvl(:emp,e.employee_id)

IN

An in predicate parameters passing a NULL value for no selection.

Configuration:

Bip In Parameter

SQL:

select division from divisions where 
(
   division in (:DivisionName)
   or (coalesce(null, :DivisionName) is null) 
)

Documentation / Reference





Discover More
Bip Bursting Properties
BIP - Bursting

To burst in BIP, you just need to fill the Bursting Properties. The SQL Query of the Bursting property defines the bursting properties. parameter in the SQL Query of the data set but also in the...



Share this page:
Follow us:
Task Runner