BI Publisher bursting with parameter to BI Server — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher bursting with parameter to BI Server

Question
32
Views
0
Comments
marcootje123
marcootje123 Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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