BI Publisher bursting with parameter to BI Server

marcootje123

Summary

BI Publisher bursting with parameter to BI Server

Content

Hi,

I have a simple question:

Does BI Publisher support use of parameters in a bursting script to the Oracle BI Server?

The situation:

I've build an OBIEE Analysis and copied the SQL in BI Publisher so that I can use a parameter to filter my incoming data (with the syntax *parameter** in my sql). This is working fine!

I've als created a LOV with fixed data for the output file type. So I have a fixed 'EXCEL' and 'PDF' in my LOV.

I also created a bursting script that goes to the Oracle BI server. The splitting is working fine but in my query I am using the above parameter so that I can choose to which file type I want to burst.

This part is not working. I am getting the error: "Unable to connect to port 9703". In the query logging I see the correct bursting SQL but there is a question mark where I expect the output 'EXCEL' or 'PDF'.

If I create the same kind of report on a database (so not the BI server) the bursting query with the parameter is working fine.

Anyone?

Thanks.

Marco