Wednesday May 20, 2015

BIP scheduleReport with Parameters

I have just spent an hour or so working on getting a sample scheduleReport web service working with parameter values. There are a lot of examples out there but none I have found have the parameters being set. Our doc is a little light on details on how to set them up :) In lieu of that, here's this!

        // Set the parameter values for the report. In this example we have
        // 'dept' and 'emp' parameters. We could easily query the params dynamically
        //Handle 'dept' parameter
        ParamNameValue deptParamNameVal = new ParamNameValue();
        deptParamNameVal= new ParamNameValue();
        // Create the string array to hold the parameter value(s)
        ArrayOfXsdString deptVal = new ArrayOfXsdString();
        // For individual values or multiples, add values to the 
        // string array e.g. 10,20,30
        // Asterisk used for a null value ie 'All'

        // add the array to the parameter object
        //Handle 'emp' parameter
        ParamNameValue empParamNameVal = new ParamNameValue();
        empParamNameVal= new ParamNameValue();
        ArrayOfXsdString empVal = new ArrayOfXsdString();
        // For individual values or multiples, add values to the string array 
        // empVal.getItem().add("Jennifer Whalen");
        // empVal.getItem().add("Michael Hartstein");

        // Asterisk used for a null value ie 'All'

        // add parameter values to parameter array        
        ArrayOfParamNameValue paramArr = new ArrayOfParamNameValue();
        //Now add array to values obj
        ParamNameValues pVals = new ParamNameValues();

 The pVals object can then be added to the report request object.


Hopefully, you can extrapolate to your code. JDev application available here, unzip and open the application.
Just the schedule report class is available here.

Tuesday May 08, 2012

Port 80 Goodness for Publisher

Do you ever tire of remembering what port BIP is running on when you enter the URL? Ever wish you could just type:


and be done with it? Well its really not that hard to do. Its documented how to front the web logic server with a web server whether that be Microsoft's IIS or maybe Apache. Well with my success at getting BIP on to my Ubuntu laptop I thought I would give Apache a whirl being as I dont think IIS would run on my machine :)

I did start off with the docs but as usual Googling got me faster, more concise instructions with some help if things went awry. Of course, BIP has nothing to do with the configuration other than to tell Apache where the xmlpserver app is running and on what port. So its really just an exercise in installing Apache and then configuring it.

Rather than re-invent the wheel, check out Vikas' blog post here -  Yes, its specific to Ubuntu but can be applied to any flavor of Linux in this case. For you 'windowers' out there, this will get you on the road to non port typing bliss,

For linux folks, just follow Vikas' excellent post and just replace the references to the 'medrec' application with 'xmlpserver' and change the port from 7011 to 7001. You can of course add the /console app to the list as well.

I have covered web logic server installs ie 11.x. If you re running earlier versions on OC4J the Oracle AS documentation is pretty good on how to get BIP on port 80.

In no time you'll have forgotten that BIP even runs on a specific port.

Tuesday Sep 13, 2011

Web Services Datasources over SSL

Great question on accessing a web service as a data source over SSL today. BIP without any configuration does not like em. Oracle of knowledge Shinji of the development team put together a couple of links and I wanted to get them out on to the intertubes and share them.


My customer is creating BIP reports that use a web service/wsdl data source.  It all works fine without SSL.  They are a financial services company and internally they are required to use ssl when retrieving data from the web service.  Trying to config to the WSDL to use SSL.  Having an issue returning data from the source due to the ssl encryption.  Errors from BIP indicate the certificate is missing, but we're not sure where it is supposed to be located.


Basically, you need to enable SSL in JVM level so that java applications run on the JVM can use SSL.
This is a generic configuration of Java and not specific to BI Publisher.

It is also documented in BIP documents.

Thursday Aug 25, 2011

WebCenter - BI Integration

A little off topic today but to be honest I'm tired of having to find the following document every time someone asks for it. I know what you're going to say, 'that's what bookmarks are for Tim, you eejit!' Indeed, but, I find it almost easier to either type the URL or Google what I'm looking for, strange I know but that's my brain, get over it, I have to, on a daily basis :0)

The document in question, filled my life for the first half of last week. Integrating OBIEE and WebCenter, the ability to drop BI content into your WebCenter Spaces pages with a few clicks. The WebCenter product management team had a document out there covering it but, it was missing the secret sauce to get the BI side set up. The result of some 'verified by customers' effort is here:

Its a monster PDF, with lots of pictures, cos they speak a thousand words right!

I should add, I need to update said document to state that, BI Publisher content is not currently supported in this integration. There are other ways to get BIP content into WebCenter but this, sadly, ain't one of them right now. I'm assured it's planned thou.

So, either give google a day or two to index this post or if you really want to, you can bookmark it, I won't hold it against you.


Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!


« June 2016