Pass a parameter value from one BIP report to another

Stewart Sims

I am trying to create an RTF template with a URL that passes a parameter value from one BIP report to another BIP report.

My summary data model creates a table with CATEGORY and AMOUNT. And in the where clause it filters on a parameters p_Category and p_Location (even though Location is not a field in the data model, I still give the option to filter on Location in the parameter).

• Category1 100
• Category2 200

I also have a detail data model with CATEGORY, LOCATION, and AMOUNT. And it also has parameters for p_Category and p_Location.

• Category1 Location1 30
• Category1 Location2 70
• Category2 Location1 50
• Category2 Location2 150

Both data models function as expected.

On my RTF template for the summary report with AMOUNT by CATEGORY, I want to build a URL on the AMOUNT that links to the detail report by CATEGORY and LOCATION based on the selections of the 2 parameters. Since CATEGORY is a field in my data model, I can use this syntax in my URL and it works great:

&_paramsp_Category=%7b.//CATEGORY%7d

But because Location is not a field in my data model, I need to pass the parameter value, not the field value, to the parameter value in the detail report. Something like this:

&_paramsp_Location=<value selected in parameter>

I cant find the correct syntax for doing this.

Stewart Sims

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

Pass a parameter value from one BI Publisher 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