Home | Ciber
Knowledge page of Ciber Netherlands

Archive for December, 2008

OBIEE Creating Bookmark and or Prompted URL

By default the Create Bookmark Link is enabled in the dashboard page options menu:

image

Read more

No comments

The Role of the Enterprise Service Bus

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.

Read more

No comments

Empty elements in XML: much ado about nothing..

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.

Read more

2 comments

OBIEE Automating the Metadata dictionary repository updates

In a previous article: (http://knowledge.ciber.nl/weblog/?p=162) I showed you how to setup the OBIEE Metadata dictionary. In practice people tend to forget to update this dictionary when the repository is brought to production and it tens to get outdated over a period of time.

Read more

No comments

OBIEE MetaData Dictionary

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)

Read more

1 comment

OBIEE LOV prompts

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:

Read more

No comments

I can see my house from here: some thoughts about Google Earth and Google Maps

Recently I was asked to take a look at the possibilities of using Google Earth and Google Maps for a possible client project. That project didn’t quite work out, but I found out some useful things about GE and GM regardless which I think are interesting enough to share here.

Read more

No comments

OBIEE bypassing the presentation / web cache

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:

 

<CacheMaxExpireMinutes>-1</CacheMaxExpireMinutes>

<CacheMinExpireMinutes>-1</CacheMinExpireMinutes>

<CacheMinUserExpireMinutes>-1</CacheMinUserExpireMinutes>

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

OBIEE using timeline graphs in pivot views

Consider the following data:

image

If we put this in a timeline graph we get:

Read more

2 comments

OBIEE Handling SCF data / PIT Reporting

Due to more and more compliance rules a lot of DWH’s these days have there data stored based on the SCF principal (Slowly Chancing Fact). A typical example of SCF data is the state of an order:

image

I

Read more

No comments