OBIEE Simulating Drill up

Post date: 06-May-2011 09:11:19

Reference: http://obiee101.blogspot.com/2009/02/obiee-simulating-drill-up.html

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