Friday, February 27, 2009

OBIEE Simulating Drill up

Every now and then I get the question if Drill up is possible within OBIEE. One way of simulating this behavior is using the preferred Drill path option. (One of the lesser documented features is OBIEE).

Chaeck out the basic Calendar Dimension:


On the Date level add the next higher level (month) in the Preferred Drill Path:


Do the same for Month (quarter), Quarter (year).

Check the result:

image image


Yeah I know it's not perfect .....

Till Next Time

No comments: