Archive for December, 2008
This was a presentation given by Mark Richards and describes the role of an ESB and particularly what it provides. It is an old presentation (23 oct 2006) but still very true, in the fact that there are still a lot of different definitions of an ESB within the world. This is a short recap of this presentation.No comments
Most XML tutorials will explicitly mention that empty elements in XML are allowed. And then surprisingly little of them will tell you what they are for. On a superficial view, empty elements are a concept to trivial to discuss. But now that many vendors support XML based integration with their products, you may be in for a surprise or two.2 comments
The metadata dictionary is a very powerful support package within OBIEE. Sadly it is not commonly used at this moment. This is mainly caused by the fact that the functionality is very poorly documented by Oracle.
This article describes the configuration and implementation of the OBIEE metadata dictionary both on an OC4J and an IIS web services. (Other web services can be easily configured based on of these systems)1 comment
The classical way of making a LOV prompt is creating SQL in the form:
SELECT case 1=0 then TABLE.COLUMN else "YES" end from BM_NAME union all SELECT case 1=0 then TABLE.COLUMN else "NO" end from BM_NAME
This always produces costly SQL since OBIEE will execute this as a SELECT DISTINT against the reference table.
Much better is to add a small LOV table to repository with it’s own business model. I created a small XLS spreadsheet with a couple of LOV’s:No comments
In addition to settings mentioned in this article: http://knowledge.ciber.nl/weblog/?p=150. You sometimes you want to bypass the presentation / cache for development purposes. Or more often when you get weird write back behaviour. Add this to the instanceconfig file:
Till Next Time
John Minkjan is a principal BI-consultant and OBIEE Product Expert at Ciber in the Netherlands, the text of this article is also published on his personal blog http://obiee101.blogspot.com/1 comment