-> Create a new parameter: ZS_PARAMETER
-> use it in your query.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjd-QpoHPWq46i0Kmbi-o2VEN34hsvkZMwf6puCPbVNi4wRJPYICWN_0Vun8_5YUv_Sc1RGVTFf1ylsEWgeAoGbbNRYwmvPOnXQVhDE48e43rs9ND8VqO6sZbI2ACj-06OzkiXsAcGdU7VJ/s200/00.png)
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.