rasti.hil@hilandco.com +41 79 367-9677

Friday, 4 June 2010

how to use parameters in BI Publisher

1) Use parameter in your sql query
-> Create a new parameter: ZS_PARAMETER
-> use it in your query.


2) Change your parameter when you call BI Publisher report from APEX
-> Create Text item on a page of APEX. (P_ITEM)
-> Create button with branch:
Target type: URL
URL Target: copy the url from BI Publisher, and change the parameter input in url: &ZS_PARAMETER=&P_ITEM.

2 comments:

meenu said...

Can i pass apex page items into the pdf form which is in bi publisher?

Zsuzsi Vadasz said...

You can use only BI Publisher parameter in report of BI Publisher.
But when you call the BI Publisher you can set the input parameters.