Rittman Mead Blog

Parsing XML Files in SQL with Custom Aggregation Function

I was recently given a task to parse an XML file in SQL that contained the definition of an OBI RPD file, which had been exported using the biserverxmlgen command line utility. The purpose of this is for quick analysis of the RPD file and subsequent mapping of the data

Technical

The Secret Life of Conditional Formatting in OBIEE

When dealing with conditional formatting the GUI allow us to add as many formats as we want, but every single format has a unique and single condition, not more, not less. In this post I am going to show how it is possible in OBIEE to use multiple conditions to

Business Insights

Web Services in BI Publisher 11g

BI Publisher 11g comes with a shiny set of new Web Services, superseding those that were in 10g. This article will discuss some of the uses, and ways to implement them. Introduction First, a quick refresher : what is a web service? I'd hasten to Wikipedia for a formal

Business Insights

Accessing BI Publisher 11g Web Services through a JDeveloper Web Service Proxy

In the second part of this series looking at Web Services in BI Publisher 11g, I will look at using JDeveloper to create a Web Service Proxy. This exposes the BI Publisher Web Services in Java, from where they can be embedded in numerous other applications. I demonstrated in part

Business Insights

Calling BI Publisher 11g Web Services from BPEL

BI Publisher 11g exposes a lot of functionality through its four new Web Services. In part one [https://www.rittmanmead.com/blog/2011/11/web-services-in-bi-publisher-11g] we looked at how we can examine the services and prototype calls into them. In part two [https://www.rittmanmead.com/blog/2011/11/accessing-bi-publisher-11g-web-services-through-a-jdeveloper-web-service-proxy/