BIP - Parameters

Card Puncher Data Processing



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)


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


Bip In Parameter


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