Saturday, December 6, 2008

OBIEE using timeline graphs in pivot views

Consider the following data:

image

If we put this in a timeline graph we get:

image

One of our customers wanted to use the graph from a pivot view to create an individual graph for each machine.

One problem.... Oracle forgot to make it available for the pivot view, it's not in the graph select dropdown list:

image

My colleague Rob van Beek found a workaround. Go to the advanced tab of the report:

image

In the Request XML look for the "pivotTableView" part.

image 

Change the saw:template tid to :

<saw:template tid="charts/linetime.cxml"

Press the set XML button:image , go to the pivot view:

You will get a warning like this:

image

This is because the pivot view template doesn't know timeline graphs. If you really want you can probably hack OBIEE to suppress the warning, but I would just leave it like this.

Press OK to ignore the warning.

In your Compound lay-out you can see the results:

image

Till Next Time

This article was originally written for the Ciber knowledge blog: http://knowledge.ciber.nl/weblog/?p=157

1 comment:

Anonymous said...

WOnderful post..