Business Intelligence – Oracle

Oracle BI Publisher – Web Services using APEX

Posted by Venkatakrishnan J on October 30, 2007

If you had read my previous blog entry here on BI Publisher SOAP APIs, you would have noticed that i had used a evaluation tool called Mindreef SOAPScope to test out the web services. I was reminded of a much better in house Oracle tool yesterday by Adrian which is none other than the Application Express. Though i have used APEX before to test Web Services, i forgot to mention about it in that blog entry. So, if you want to test out BI Publisher Web Services, APEX would be best tool to start with. I thought i would write about it here today since APEX is a free tool and you can test web services out of the box using this.

1.   Log into your workspace in APEX. Create a new application with some blank pages. Navigate to the shared Components and click on Web Services References. Let us create one for BI Publisher. Ensure that you are not searching the UDDI registry since we have a WSDL already defined.



As you would see, APEX would show all the methods that are exposed. Remember that APEX currently supports WSDL with only one SOAP binding. One cannot use(i am not sure whether one can use manual registration to register multiple SOAP binding WSDL) multiple SOAP binding WSDL like the BI EE WSDL.

2.   Lets test out the simple validate login method. Lets create a simple form based on this Web Service in APEX.


Now lets enter the username and passwords to see the login method actually works. When i click on submit, the Validateloginreturn will get the value of true which basically indicates that this method has successfly got completed.


The above is pretty straightforward. But it is worth a mention since you can use APEX to test out all the methods and of course it would come very handy if you want to build a sample application which would call all these web services.

3 Responses to “Oracle BI Publisher – Web Services using APEX”

  1. prekris said

    Hi Venkat,
    Is it possible to have a presentation dashboard login page (i.e “http://localhost:9704/analytics/saw.dll?Dashboard”)with a cutomised message such as “Currently the Presentation services maintenance going on.Try again later” when the presentation services is actually down instead of displaying “Firefox can’t establish a connection to the server at ….”

  2. Venkatakrishnan J said

    The problem with that kind of a scenario is you would never know if the Presentation Services has actually gone down. Whenever there is some actual maintanence on the Presentation Services you can have a manual redirect enabled so that all the queries to the web server will be directed to a single static web page with any customized Text that you want. You can disable it as soon as the Presentation Services is up and running.

  3. Raj said

    Hi Venkat,

    Im facing issue in Getreportparameters method, its returning NULL.

    Jdev & BIP version.

    Kindly help.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: