OBIEE Calendar Control View

An alternative view to presenting data to the user. Try this...

select month year, year week,Day of week ,and  measure column...

Month year:

Evaluate('TO_CHAR(%1,%2)' as character(30), "D5.Times"."Day Date"  ,'MON-YYYY')

Year week :

WEEK_OF_YEAR("D5.Times"."Day Date")

Day of the week:

CAST(DAYOFWEEK("D5.Times"."Day Date") as varchar(2)) || ' - '||DAYNAME("D5.Times"."Day Date")

Budget:

 '<b>'||cast("D5.Times"."Day Date" as char)||'</b><br><P STYLE="text-align: right;">'||CAST("XXX"."Budget PJTD" AS char)

 

It concats the date with the fact and adds some HTML Formatting
Alter the column properties [data format] to HTML:

Put it all in a pivot view 

 

 Check the results: