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