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:

image

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

image

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

Check the result:

image image

image

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

Till Next Time

No comments: