Oct22

Calendar View in OBIEE and Applications

Posted on October 22, 2010 by Kishore & Naresh

Hi…

Calendar View in OBIEE with Year selection.

Here is the Pivot Layout, you can see the columns used ..

Don’t forget to set an aggregation rule to Max or Min (not sum) for Day Number column there in Measure block of Pivot.

Calendar Week is the column which treat Sunday to Saturday as one week from day starting of year, but not like 1 to 7 is one week, 8 to 15 is 2nd week…

Here is the output:

Applications are like:

Enable a drill report on the day number column to know the transactions for that date..

(it’s not straight forward.. but, possible. If i get time, i’ll come up with an article about that.. )

Please propose other applications on this, i’ll appreciate it .. 🙂

—

Regards,

Kishore Guggilla.

6 responses »

John on October 26, 2010 at 2:17 PM said:

Very good article in displaying calendar.
But can you show any practical example for this?

~ Johnson

Reply ↓
Adrian Ward on October 27, 2010 at 12:07 AM said:

An excellent example of simple but effective use of OBIEE

Reply ↓
Remc0 on October 29, 2010 at 11:36 AM said:

You just helped me out on the oracle forum, so I had a look at your site! nice site!!

Here you have a nice link for some more advanced calendar stuff with the usage of mootools pls check: http://obiee101.blogspot.com/2010/05/obiee-events-calendar.html

Reply ↓
- Kishore & Naresh on October 31, 2010 at 12:52 PM said:
  
  Thanks a lot
  
  Reply ↓
Anand on December 2, 2010 at 4:00 PM said:

H i

where I will get the base tables I want to include the Calendar in OBIEE

Reply ↓
- Kishore & Naresh on December 3, 2010 at 5:50 AM said:
  
  If you’ve calendar Date column, you can derive everything in either rpd or front-end answers using date functions… Or, if you’ve time dimension like w_day_d, it contains everything..
  
  Reply ↓