OBIEE using timeline graphs in pivot views

Consider the following data:

If we put this in a timeline graph we get:

OBIEE Missing BI-Office add - in

Erik did a good one: http://bidwcz.blogspot.com/2008/12/chybjc-bi-office-add-in-me-se-to-stt-i.html But since most of you (including me :) ) don't speak or read Czech here is a translated summery:

If you a "missing" the  OBIEE office plug in after you did an install and think it should be there, try this:

In your MS Office application grotto Help> About MS Office> Disabled Items >

Press Disabled Items  and check if the OBIEE Office add in is the list.

Till Next Time

OBIEE BI-Publisher Templates

Found this one on the NET:

http://www.oracle.com/technology/products/xml-publisher/demoshelf/Shelf.html

 

Till Next Time

OBIEE 1K Status

Not only is it our first birthday today, but we also passed the 1K pageview per day border for the first time. Another proof that OBIEE is alive and kicking!

:-) Till Next Time

OBIEE101 First Birthday

Yes, OBIEE101 has become 1 today! Thanks everybody for the On- and Off-line input!

Till Next Time

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:

If you want to do PIT reporting (Point In Time) you need to use the SCF columns:

One possible solution track is using creating a SCF_IS_PIT column in the repository based on a repository variable.

First let's create a PIT_DATE session variable:

Next create the column:

Our data will now look like this (Current date = 03-DEC-2008"):

If we add a filter to our report :

we only get "CURRENT" data:

For most users this is the information they are looking for. For those who need to go "back in time" with the same report, you simple add a prompt to the dashboard allowing them to set the PIT date:

Till Next Time