Calendar View in OBIEE and Applications



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 .. 🙂


Kishore Guggilla.



About Kishore & Naresh

Hi.. This is a blog operated by Kishore and Naresh. We are colleagues and working as BI Developers. Here we want to share our ideas and researches here. We were the active members of OTN Forums and inspired with Venkat and John's blog. We may not reach to that level, but we brings up all our ideas and research work we done. All the views expressed here are our own and does not reflect the views of our employers. We need all your blessings and support to grow. Thanks

6 responses »

    • 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..

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s