Pass a parameter value from one BI Publisher report to another

Stewart Sims

I would like to build a URL where I can pass a parameter value from one BI Publisher report to a parameter value in another BI Publisher report.

Let's say I have a data model that contains Category and Amount and it has a where clause that filters on the selection of a parameter "p_Location". And assume the data model works. When I select a specific location in the parameter, my category and amount is filterd to that location.

When I build an RTF template my report looks like this:

Location parameter: p_Location (shows value of parameter that is selected)

• Category1 100
• Category2 200
• Category3 300

The amounts have url links to a detail report by category and location. The url works fine for the category (so if they click on the amount for Category1, it will filter the detail by only Category1). The detail report has parameters for p_Category and P_Location. The url looks like this:

serverurl/path/reportname.xdo?&_paramsp_Category=%7b.//CATEGORY%7d

But I want to also pass the value of P_Location in the summary report to the value of P_Location in the detail report.

Something like: serverurl/path/reportname.xdo?&_paramsp_Category=%7b.//CATEGORY%7d&_paramsp_Location=<value of p_Location>

But I cannot find the syntax needed to do that.

Stewart Sims

This is a duplicate post by mistake. The other post is:

Pass a parameter value from one BIP report to another — oracle-products

Oracle support helped me with the answer: Use this syntax to pull a parameter value into your URL to pass on to another report:

serverurl/path/reportname.xdo?&_paramsp_Category={.//CATEGORY}&_paramsp_Location={/DATA_DS/P_LOCATION}

Where P_LOCATION is the name of the parameter you want to pass